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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 1004: Select method of worksheet class failed 3
Run-time-error 1004 "ListIndex method of listbox class failed" 1
1004 Error: Unable to set the LineStyle property of the Border class 1
Sheets visible toggle code 3
Can't delete sheets 8
"Run-time error '1004' 5
Unable to set the Visible property of the Worksheet class 1
Run Time Error '1004' 1

Back
Top