I have the below code that successfully hides all my sheets bar one if the excel document is open without macros enabled.
My problem is though when I add the below code this prevents the above code from working. The below code prevents the user from saving a copy of my spreadsheet, they both work fine sperately but once I put both bits of code into my workbook the above code stops working. Any help is greatly appreciated!Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks