Hi,
I want to protect the ONLY Sheets 1,2 and 3 in my workbook.
SO, I don't want the user to be able to delete / rename / hide the sheets 1,2 and 3 in the workbook. The workbook has additional sheets 4,5 and 6. The user should be able to hide / delete / rename any of these sheets except 1,2 and 3.
Is there a way to achieve this with VBA ?
Protect Workbook
Open a workbook.
On the Review tab, in the Protect group, click Protect Workbook.
Check Structure, enter a password and click OK. Note: The Windows option is not available in Excel 2013 and later versions.
Reenter the password and click on OK.
Is this what you are after
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
Oh nice guide. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks