Try to unprotect your workbook from Tools menu before you unhide/Hide sheets.
I had the same issue and by unprotecting the Workbook I was able to Unhide the worksheets.
Error - Method ‘Visible’ of object’_Worksheet’failed
-
- NewLounger
- Posts: 1
- Joined: 13 Sep 2010, 14:18
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Error - Method ‘Visible’ of object’_Worksheet’failed
Thank you RyanRio115
Thats what I ended up doing, I first took a previous version that worked correctly and then I added the updated changes and also added
Before code
And after code
This seemed to resolve my problem
Just as you mention
Thank you again
Thats what I ended up doing, I first took a previous version that worked correctly and then I added the updated changes and also added
Before code
Code: Select all
ActiveWorkbook.Protect Structure:=False, Windows:=False
Code: Select all
ActiveWorkbook.Protect Structure:=True, Windows:=True
Just as you mention
Thank you again