Excel Password control

TROY c 60 Reputation points
2024-04-09T15:23:01.35+00:00

I would like to use a button to unprotect a worksheet.

Currently while modifying a worksheet that is protected, I either have to go into the macros and edit out all the protection instructions and then put them all back again or enter in the password every time I select another cell.

Neither option works, takes to much time.

If I could just hit a btn life would be so much easier.

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.