UNHIDE Columns by entering password

[meadmoon]

I'm working on a Client Update sheet which I will share with the several stakeholders but will also serve as a masterlist for my team...Columns D:I and P:P are internal notes which are supposed to be hidden at all times and can be Unhidden by clicking "Admin Only" button to prompt for a password, once this is satisfied then the columns with internal notes will be shown. I'm really new to this and cant figure out how to password ptotect it, I can only hide and unhide...please help. attached is what I have now. ClientUpdates_0723.xlsm

[ARGK]

Hi
Follow this link.
Good luck.
Tony

[martindwilson]

missing link?

[AndyLitch]

If you protect the worksheet allowing all activities but Column editing it will prevent casual users from unhiding your columns.

[ARGK]

Hi
Here is the link:

http://www.mrexcel.com/forum/excel-q...-possible.html

Tony