Can not access worksheet unprotect in an Excel worksheet that I have been using for several weeks

%3CLINGO-SUB%20id%3D%22lingo-sub-3278019%22%20slang%3D%22en-US%22%3ECan%20not%20access%20worksheet%20unprotect%20in%20an%20Excel%20worksheet%20that%20I%20have%20been%20using%20for%20several%20weeks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3278019%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20worksheet%20I%20created%20and%20have%20used%20for%20several%20weeks.%20%26nbsp%3BIt%20has%20several%20Macros%20and%20many%20of%20the%20cells%20are%20protected.%20%26nbsp%3BNow%20it%20is%20not%20working%20correctly.%20%26nbsp%3BIt%20can%20be%20opened%20and%20the%20unprotected%20cells%20are%20available.%20However%2C%20the%20sheet%20can%20not%20be%20unprotected.%20Unprotect%20buttons%20are%20visible%20but%20are%20greyed%20out%20and%20not%20accessible.%20Most%20of%20the%20Macros%20do%20some%20sorting%20of%20data%20and%20will%20not%20run%2C%20I%20assume%2C%20because%20of%20the%20locked%20cells.%20This%20problem%20involves%20only%20this%20worksheet.%20%26nbsp%3BThe%20other%20workbooks%20and%20sheets%20work%20fine%20and%20I%20can%20create%20new%20sheets%20with%20Macros%20and%20protect%20and%20unprotect%20%26nbsp%3Bthe%20new%20sheets.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3278019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3278571%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20not%20access%20worksheet%20unprotect%20in%20an%20Excel%20worksheet%20that%20I%20have%20been%20using%20for%20several%20week%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3278571%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1355488%22%20target%3D%22_blank%22%3E%40Bill_T82D%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20some%20links%20with%20information%20on%20how%20to%20unlock%20yourself.%3C%2FP%3E%3CP%3E1%20Link%3A%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fpassword-options%2Fm-p%2F2399518%22%20target%3D%22_blank%22%3EPassword%20Options%3C%2FA%3E%3C%2FP%3E%3CP%3E2%20Link%3A%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fhow-to-unprotect-the-excel-sheet-if-forgot-the-password%2Fm-p%2F1574559%23M71532%22%20target%3D%22_blank%22%3EHow%20to%20unprotect%20the%20excel%20sheet%20if%20forgot%20the%20password%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20with%20these%20links.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a worksheet I created and have used for several weeks.  It has several Macros and many of the cells are protected.  Now it is not working correctly.  It can be opened and the unprotected cells are available. However, the sheet can not be unprotected. Unprotect buttons are visible but are greyed out and not accessible. Most of the Macros do some sorting of data and will not run, I assume, because of the locked cells. This problem involves only this worksheet.  The other workbooks and sheets work fine and I can create new sheets with Macros and protect and unprotect  the new sheets.

1 Reply

@Bill_T82D 

Here are some links with information on how to unlock yourself.

1 Link:Password Options

2 Link:How to unprotect the excel sheet if forgot the password

 

 

Hope I could help you with these links.

 

NikolinoDE

I know I don't know anything (Socrates)