Hi All,
I have a workbook with a visible sheet and 'very hidden' protected multiple sheets. See attached 'Sheet1' as visible, 'Sheet2' and 'Sheet3' as protected very hidden.
I used the following code to unhide the sheets which worked fine in the past but it looks like it does not do anything when I run it now. I open VBA double click on 'Thisworkbook' and insert the code there but nothing happens. when I used previously, after running the code it opened a new normal excel workbook (no macro-enabled) with all the sheets visible. Could you please let me know where I go wrong and advise please?
Thanks
Bookmarks