Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to hide workbook "title bar" | Excel Discussion (Misc queries) | |||
Backup to specific folder if workbook names begins with "NSR" or "MAC" | Excel Programming | |||
save and restore "Workbook Menu Bar" & "Cell" menus | Excel Programming | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |