On 27 aug, 23:50, Valter wrote:
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 :)

Is your workbook in Shared Mode?
If so, it's unpossible to protect/unprotect

Hanno