I have hided a sheet in a file which contains calculations and the working sheet is protected but many calculations are linked with the hide sheet but the user is easily can unhide it so it there any solution to protect the calculation sheet by giving password, means if the user trying to unhide the sheet then it will prompt a password, If anyone knows the solution please help me thanks in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Unhide sheet
- Thread starter jitendra
- Start date
Jonmo1
MrExcel MVP
- Joined
- Oct 12, 2006
- Messages
- 44,061
You can set the sheet to VeryHidden
Press ALT+F11 to open the VBA editor window..
Click View - Project Explorer
Locate and click on the appropriate sheet
Click View - Properties Window
Locate the property called "Visible"
Change it to xlSheetVeryHidden
Now the sheet will not be visible via format - sheet - unhide
And of coarse, reverse the process to unhide the sheet.
but still, if user's know anything about VBA, they might figure this out too..
To prevent that, you can password protect the VBA project by
clicking Tools (in the VBA window) - VBA Project Properties - Protection
Check "Locked for editing"
Enter a password
click OK
click SAVE
Press ALT+F11 to open the VBA editor window..
Click View - Project Explorer
Locate and click on the appropriate sheet
Click View - Properties Window
Locate the property called "Visible"
Change it to xlSheetVeryHidden
Now the sheet will not be visible via format - sheet - unhide
And of coarse, reverse the process to unhide the sheet.
but still, if user's know anything about VBA, they might figure this out too..
To prevent that, you can password protect the VBA project by
clicking Tools (in the VBA window) - VBA Project Properties - Protection
Check "Locked for editing"
Enter a password
click OK
click SAVE
Upvote
0
