Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
All sheets unaccessible
I am working on a rather large excel file (3.6MB) with about 18 modules
of VBA code. One of the modules failed with the error message "Run-Time error '1004' Method: 'Range' of object '_Global' failed" Once this occured I was stupid enough to save. The problem now is that I can't see any of the worksheets. The problem is not that they visible property is set to false as I have run the following code Sub Un_Hide_All() Dim sh As Worksheet For Each sh In Worksheets sh.Visible = True Next End Sub Does anyone have any idea what could be causing the problem or any way I can work around the problem Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
All sheets unaccessible
Maybe the Workbook is hidden ?
WindowUnhide NickHK wrote in message oups.com... I am working on a rather large excel file (3.6MB) with about 18 modules of VBA code. One of the modules failed with the error message "Run-Time error '1004' Method: 'Range' of object '_Global' failed" Once this occured I was stupid enough to save. The problem now is that I can't see any of the worksheets. The problem is not that they visible property is set to false as I have run the following code Sub Un_Hide_All() Dim sh As Worksheet For Each sh In Worksheets sh.Visible = True Next End Sub Does anyone have any idea what could be causing the problem or any way I can work around the problem Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is most of the sheets gray and unaccessible? | Excel Discussion (Misc queries) | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Programming | |||
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming | |||
Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming |