Forum Discussion
Copy Sheet
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.
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.
