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.
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