VBA/Macro Button Password Protection

simo758

New Member
Joined
Mar 6, 2019
Messages
2
Hi All,

I developed a tool for employees in different dept. and the tools automatically captures data filled and send it to the tables (Which i created in different tabs, which are hidden from the employees). After that comes a validation tab where only managers are allowed to see it. The buttons in the validation tab send you directly to the sheet pressed on for data review.
My question is, How c
an
i lock/unlock those button to be pressed by managers, using a password. . I attached a screenshot for explanation.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,109,522
Messages
5,529,329
Members
409,863
Latest member
stacy09
Top