Can you "very hide" a workbook?
 

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.

Can you "very hide" a workbook?
 

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

"XP" wrote:

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.

Can you "very hide" a workbook?
 

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


"XP" wrote in message
...
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.

Can you "very hide" a workbook?
 

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

"Pflugs" wrote:

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

"XP" wrote:

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.

Can you "very hide" a workbook?
 

My mistake.

"XP" wrote:


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

"Pflugs" wrote:

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

"XP" wrote:

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.

Can you "very hide" a workbook?
 

No problem, thanks for the effort...

"Pflugs" wrote:

My mistake.

"XP" wrote:


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

"Pflugs" wrote:

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

"XP" wrote:

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.