unprotect options

AI Training: For Busy Decision Makers & Professionals Book now

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Unprotect options

Unprotect options

resolvedResolved · High Priority · Version 2007

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

RE: unprotect options

Thanks Amanda.

Cheers
Abhi


 

Excel tip:

Convert Text into Number

Some 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

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips


Server loaded in 0.11 secs.