Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Unprotect options
|
|
|
Bookmark this page|
The UK's most regular 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
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 AbhijitThank 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
|
 |
|
» Forum post: Slide masters |
Should all slide masters be saved as templates.
