Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code, that produces an error 400 when the macro
sub routine is run by itself. What I want it to do, is out a number of sheets in a workbook, when the workbook closes, all sheets will be veryhidden except one called "Welcome". As you can probably tell, I am trying to make use of the 'force macros' style of hiding important sheets before macros are enabled. If macros are disabled, then the only sheet visible will "Welcome" ----------------------------------------- Sub workbook_before_close() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Visible = xlVeryHidden Next ws Call Show_Welcome Application.SaveWorkspace End Sub ----------------------------------------- What is the problem with what I have typed? Is there a better way of hiding a range of sheets that are not called Welcome? All comments are welcomed (as is any replacement code!) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
run-time error '91'-Close Button error | Excel Discussion (Misc queries) | |||
commandbar at workbook before close - run time error | Excel Programming | |||
commandbar at workbook before close - run time error | Excel Programming | |||
Close a the current workbook and load another specified workbook | Excel Programming | |||
When running workbook.close True Excel generates an error!!! | Excel Programming |