Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheets.select doesn't work
The following code keeps failing on the last line, the one after On Error: Private Sub Workbook_Open() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets Select Case Left(ws.Name, InStr(ws.Name, "_")) Case "GM_" ws.Visible = xlSheetVisible Case "Data_" ws.Visible = xlSheetHidden Case "VBA_" ws.Visible = xlSheetVeryHidden End Select Next ws On Error Resume Next ThisWorkbook.Worksheets("Front Page").Select ' <<< - fails here End Sub If I don't have the On Error statement in there, it crashes with a Runtime error '57121" Application-defined or object-defined error Darren |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get VBA to work without select | Excel Discussion (Misc queries) | |||
.End(xlRight)).Select Doesn't Work | Excel Programming | |||
Cells.Select won't work!!! | Excel Programming | |||
Why doesn't Selection.End(xlDown).Select always work? | Excel Programming | |||
Why doesn't Selection.End(xlDown).Select always work? | Excel Programming |