| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '1004' - Unable to set the Visible property of the Worksheet class
Excel 97
All of a sudden I am getting the above error on an existing workbook when activating and deactivating worksheets using VBA e.g. Private Sub CommandButton3_Click() Worksheets("WABC").Visible = True Worksheets("WABC").Select End Sub The above procedure has worked previously and I cannot understand why this is happening. Any help would be appreciated. Thanks Shal |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error 1004: Unable to get the axis property | Charts and Charting in Excel | |||
| VBA error: Unable to set the Values property of the Series class | Charts and Charting in Excel | |||
| Error 1004 - unable to set the orientation of the page setup class | Excel Programming | |||
| Unable to set the colorIndex Property of the Interior Class Error | Excel Programming | |||
| HELP!! Excel 2000 Copy of worksheet class failed run time Error 1004 | Excel Programming | |||
Threaded Mode
