Abhijit has attended:
Excel VBA Intro Intermediate course
Unprotect options
I have a workbook which contains protected s/s.
When I right click on one of the s/s, all the options of Insert / Rename / Move or Copy / Delete / Hide / Unhide / Tab color options are disabled. The only options available are View Code & Protect Sheet.
How do I enable the Insert / Rename / Move or Copy et al options?
Thanks
RE: unprotect options
Hello Abhijit
Thank you for your question.
The options will be disabled because protection is applied to the spreadsheet. You don't have the option to tick to say you'd like to still be able to perform these actions when setting up the protection; so I think you can either remove protection so you can use these options; or have the spreadsheet protected but have these options disabled.
Kind regards
Amanda
