Juriemagic
06-05-2015, 03:42 AM
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!
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!