hello
I have many sheet I would protect each sheet separately by specific password then when move sheet to another then show inputbox ask me the password if the password right then show the sheet if it's not then show message the password is wrong and return the main sheet .
if I move to another sheet like sheet 2 or 3 or 4 then I have to write the right password and if it's wrong then select the main sheet and the username can't see any data for any sheet except the sheet main.
the main sheet calls "main"
thanks
I have many sheet I would protect each sheet separately by specific password then when move sheet to another then show inputbox ask me the password if the password right then show the sheet if it's not then show message the password is wrong and return the main sheet .
if I move to another sheet like sheet 2 or 3 or 4 then I have to write the right password and if it's wrong then select the main sheet and the username can't see any data for any sheet except the sheet main.
the main sheet calls "main"
thanks