Copy Sheet

New Contributor

this is a very simple task, use it a lot.  for some reason, when right-click on sheet to Copy, all is grayed  out except Protect Sheet and View Code.  What causes this?

3 Replies


Activate the Review tab of the ribbon.

Is the Protect Workbook button highlighted? If so, the structure of the workbook has been protected, so you cannot rename, copy, move, hide or delete the worksheet.

Click the Protect Workbook button to unprotect the workbook. You may have to provide a password.

@Hans Vogelaar 


it is PW protected, must have done that by mistake.  Can't remember PW.  is there a way to recover forgotten PW?


I fear it's against the rules to tell you here, but if you use your favorite search engine to search for excel forgot workbook password you should find solutions.