Hi there
Is there anyway possible when recording or writing a macro to be able to unlock a password protected sheet then relock and repassword (very important) the same sheet once i have finished with the sheet?
I have tried to make a macro to password protect the sheets. Whilst it protected the sheet it wouldn't put the password in.
Thank you in advance
Is there anyway possible when recording or writing a macro to be able to unlock a password protected sheet then relock and repassword (very important) the same sheet once i have finished with the sheet?
I have tried to make a macro to password protect the sheets. Whilst it protected the sheet it wouldn't put the password in.
Thank you in advance