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.
|