Forum home » Delegate support and help forum » Microsoft Excel Training and help » Unprotect options
|
|
|
Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Unprotect options
Resolved · High Priority · Version 2007
Reply Delegate Abhijit said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Delegate Abhijit said...
RE: unprotect options
Thanks Amanda.
Cheers
Abhi
|