Run-time error '1004' - Unable to set the Visible property of the Worksheet class

  • Thread starter Thread starter Shalin Chopra
  • Start date Start date
S

Shalin Chopra

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
 
Try changing the .takefocusonclick property to False for your commandbutton.

or add
activecell.activate
near the top of your code

This is a bug in xl97 that was fixed in xl2k.
 
Hi
Is the workbook (rather than the worksheet) protected? You can't
change the structure of the workbook (like making a sheet visible) if
it is.

regards
Paul
 
Thank you all for your help. The workbook had inadvertently been
protected and this was the cause of this error. Works perfectly now.

Cheers
Shal
 
Back
Top