How to run macro on Excel 2007 protected sheet?
I have a Excel 2007 file, and want to run macro on the protected sheet. It
gives error at the very begining. I've found some sugestion using the
following code:
Sheets("Purchase Order Template").unprotect Password:="password"
and
Sheets("Purchase Order Template").protect Password:="password"
but it still doesn't work. Any idea what might do the trick? Thanks :)
|