Is there a way to exit a sub to prevent a user UNHIDING(or HIDING) a sheet unless their username is a set name as below, but triggered by the user attempting to Unhide the sheet (right clicking on a Tab>Selecting a Sheet to Unhide)?
Please Login or Register to view this content.
Hi, coreytroy,
you may use xlSheetVeryHidden which is only available from the VBE, and I won´t rely on Application.Username but take the name of the system instead:
And I try to avoid the Worksheet_Deactivate-Event and use the Worksheet_Activate instead:Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks