Vba lock a sheet with password
Solved
zahr kall
Posted messages
63
Status
Membre
-
domicol Posted messages 54 Status Membre -
domicol Posted messages 54 Status Membre -
Hello,
I want to lock my Excel sheet. So I'm using
ActiveSheet.Unprotect
then
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
between the applied macros.
However, when the sheet is locked and someone tries to write on it, a message appears indicating how to unlock the sheet.
I would like to know if there is a similar formula that allows the use of a password or if there is a way to hide the information provided by Windows Excel regarding unlocking the sheet.
I hope I have been clear and thank you in advance for your invaluable help!!!
I want to lock my Excel sheet. So I'm using
ActiveSheet.Unprotect
then
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
between the applied macros.
However, when the sheet is locked and someone tries to write on it, a message appears indicating how to unlock the sheet.
I would like to know if there is a similar formula that allows the use of a password or if there is a way to hide the information provided by Windows Excel regarding unlocking the sheet.
I hope I have been clear and thank you in advance for your invaluable help!!!
Thank you very much, Le Pingou. I didn't think it was that simple!
--
Regards.
Jean-Pierre