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.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,883 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,893 questions
{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.