Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Unprotect options
Resolved · High Priority · Version 2007
Abhijit has attended:
Excel VBA Intro Intermediate course
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
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
|
Excel tip:Convert Text into NumberSome times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions |
We'll call during UK business hours
Server loaded in 0.11 secs.