VSTO property for hidden Excel sheets

Hot Topic

Error: "data\rights.dat is already open"
Winfx SelfHosted webservice over HTTPS
C# Properties and WCF
Crysal Reports "Publish" error when Building in vs2005
Handling pop up window such as SaveAs in .Net 2003 AddIn
viaUri
Beta2 microsoft.common.targets errors
UDP Sample slow ...
Hand-made COM interop dll as COMReference
Troubleshooting: duplicate generated files

Visual Studio

Office add-in does not load on Windows Server2003 in terminal mode
Deployment problems
Most flexible deployment is to GAC?
Help still broken
What support does DLinq have for SQLXML, and can I do XLinq queries with it?
Why is a hidden VSTO document grabbing input focus?
Running multiple templates simultaneously giving an error
Xbab applications not running from the internet
VSS 2005 without Team System
Print Button RC

VSTO property for hidden Excel sheets

Is there a property on one of the VSTO classes or interfaces that allows one to determine whether a particular worksheet in the current workbook is hidden I am currently hiding some of my sheets via Format->Sheet->Hide on the main toolbar, and I would like to be able to identify the hidden sheets programmatically.

TIA,

Nick Keller

Software Developer/Analyst

Mercury Media

Answer this question

VSTO property for hidden Excel sheets

  • tommyligo


    You can go through your collection of sheets and check for visibility:

    That would give something like this:

    VB

    If Not CType(Globals.ThisWorkbook.Sheets(1), Excel.Worksheet).Visible = _
    Excel.XlSheetVisibility.xlSheetVisible Then
    ...

    C#

    if (((Excel.Worksheet) Globals.ThisWorkbook.Sheets[1])
    .Visible != Excel.XlSheetVisibility.xlSheetVisible)
    ...

    -= Maarten =-



  • VSTO property for hidden Excel sheets
Answer this question