Can you "very hide" a workbook?

[Guest]

Using Office 2003 and Windows XP;

You can "very hide" a sheet.

You can "hide" a workbook.

But, can you "very hide" an Excel workbook using VBA? Or, can you "very
hide" an instance of the application? If so, what would the VBA look like?

Thanks much in advance.

 

[Guest]

Yes. Very Hidden hides the worksheet and prohibits the user from unhiding it
through the Format -> Sheets -> Unhide menu.

Here's the code:

Sub veryHidden()
Worksheets("mySheet").Visible = xlVeryHidden
End Sub

HTH,
Pflugs

 

[Peter T]

There's nothing directly equivalent however, temporarily or even permanently
changing the workbook's IsAddin status achieves same. Ie no visible sheets
and not shown under Window > Unhide. The workbook's project remains visible
in the VBE, as does an xlSheetVveryHidden sheet.

Dim wb As Workbook
Set wb = Workbooks("VeryHiddenBook.xls")
wb.IsAddin = True

Concerning your second question, with automation you can choose whether to
make the Excel instance Visible.

Regards,
Peter T

 

[Guest]

I'm asking about the WORKBOOK or the APPLICATION; not a sheet...

 

[Guest]

My mistake.

I'm asking about the WORKBOOK or the APPLICATION; not a sheet...

 

[Guest]

No problem, thanks for the effort...

My mistake.