Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide a sheet
Is there an ActiveWorkbook... macro command to hide the current worksheet?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide a sheet
In article ,
says... Is there an ActiveWorkbook... macro command to hide the current worksheet? Turn on the macro recorder (Tools | Macro Record new macro...) hide the current worksheet and turn off the recorder. Switch to the VBE. XL should have generated the necessary code for you. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide a sheet
Tushar Mehta wrote:
In article , says... Is there an ActiveWorkbook... macro command to hide the current worksheet? Turn on the macro recorder (Tools | Macro Record new macro...) hide the current worksheet and turn off the recorder. Switch to the VBE. XL should have generated the necessary code for you. Thanks. I have the code to hide the current worksheet. I'm now looking for code to hide a specific named worksheet. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide a sheet
Good afternoon Kent McPherson Yes. Try this: ActiveSheet.Visible = False Just remember not to try this on a workbook with only one sheet, as a error will be returned. At leastOne worksheet must always be visible. HTH Dominic -- dominic ----------------------------------------------------------------------- dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893 View this thread: http://www.excelforum.com/showthread.php?threadid=39092 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Sheet, Hide Sheet | Excel Discussion (Misc queries) | |||
Hide/unhide sheet macro based on cell calculation | Excel Programming | |||
hide sheet tab | Excel Programming | |||
hide sheet? uncheck sheet tabs? or ??? | Excel Programming | |||
Hide Sheet | Excel Programming |