Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code that, on close, it hides all the Sheets
except Splash. Problem is I'm getting a debug on - ws.Visible = xlVeryHidden It says - Unable to set the visible property of the worksheet class I've all sheets protected and running 2003 Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim sh As Worksheet For Each ws In Worksheets If ws.Name = "Splash" Then ws.Visible = True Else ws.Visible = xlVeryHidden End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I stop the close method in an auto close macro | Excel Programming | |||
In Before Close Sub ActiveWorkBook.Close(False) repeat procedure | Excel Programming | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
Open / Close Workbook Memory issue | Excel Programming |