Saturday, March 27, 2010

How to work with protected excel workbook


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