Dec 30 2021 08:53 AM
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?
Dec 30 2021 11:28 AM
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.
Dec 30 2021 12:53 PM
it is PW protected, must have done that by mistake. Can't remember PW. is there a way to recover forgotten PW?
Dec 30 2021 01:36 PM - edited Dec 30 2021 01:37 PM
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.