Good evening everyone,
does being not good in English I went through a translator
infact I have a workbook with a sheet that call "admin" with my username in column A password in column B and the name of my leaves C, D, E, F, I inserted a capital X on the line corresponding to the User column of the page to which I wish him given access if no X and hide this page
this is its gets complicated in fact I wish I could restrict access for some read-only user, and for others the total change.
you tell me add a password to the sheet but I would like this to be so kind to automate the user "Admin" to log in my userform it otez protect him because he will have total access to the reading workbook + modification.
if the user "Bernard" normally has access to the sheet 1 may continue to read my not change
I hope to have was clear in my description
thank you in advance for your assistance
if you had any questions do not hesitate I am behind the pc
here is my code currently used for identification in my file
here is my page Admin
Capture.PNG
Bookmarks