Password Protect a Macro Button

[Jatli]

I am working on a spreadsheet of a staff schedule and I want to add macros so that each staff can only see their shifts and have a RESET button to see the entire schedule. However, I do not want all the staff to see all the schedule. Is is possible to put a password on the RESET button so that whoever hits it has to enter the password before it will do it's thing.

 

[horrellbt01]

Check this out and see if that would work for you

https://www.mrexcel.com/forum/excel-questions/41573-possible-password-protect-button.html