If you have protected your workbook with a password and it also has a macro in it... you got to use the below codes
.... at the beginning of your program
ActiveSheet.Unprotect Password:="Password1234$$".
..
your coding goes here. .
....... at the end of your program
ActiveSheet.Protect Password:="Password1234$$"

No comments:
Post a Comment