Error - Method ‘Visible’ of object’_Worksheet’failed

[RyanRio115]

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.

[ABabeNChrist]

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

Code: Select all

ActiveWorkbook.Protect Structure:=False, Windows:=False

And after code

Code: Select all

ActiveWorkbook.Protect Structure:=True, Windows:=True

This seemed to resolve my problem
Just as you mention
Thank you again