-
Disable Protect/Unprotect button on the ribbon
Hi there!,
There are some examples of how to disable the "protect sheet" button on the Excel ribbon, but have not found anything on the topic for Excel 2013. I have a workbook which contains several sheets. One of the sheets protect and un-protect via VBA. When certain selections are made, VBA will unprotect the sheet, wait for the input and protect it again. No passwords are involved here. I was wondering if I could prevent users from manually clicking "Un-protect sheet" button, by having the button dis-abled via VBA. Can this be done?. Please, all and any help will be greatly appreciated!. Thank you people!
-
-
Hi Kenneth,
I have already found this site and have started looking at it...wow, looks kind of involved. Thanx for responding, I do appreciate that..have a blessed day..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules