Unhiding/Hiding right click options

  • Thread starter Thread starter LavaDude
  • Start date Start date
L

LavaDude

I wanted to copy a sheet from an excel file and paste to another file. The
problem is, when I right click on the sheet name, the option for "Move or
Copy..." has been greyed out.

Is this because the sheet has been protected? ... How can I do this type of
protection for spreadsheets I create? ... Where only certain functions are
greyed out...

Thanks! ...

LavaDude
 
If you protect the workbook, you can see this option greyed out.

Tools|Protect|Protect workbook
Is how you would set it.

If you see "Tools|Protect|unprotect workbook", then it is protected.

You may need a password to unprotect the workbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting issue 5
Series fill only copying and fill series greyed out 1
Hide Print Unhide 1
Mouse Right Click Greyed Out 1
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
adding elements to an existing list 4
Listing Comments 2
Hide/unhide 4

Back
Top