works in Xl2000 but notXl97 - help required
 

Hi

The following line works in Excel 2000 but gives an error in Excel 97

Sheets("Summary").Unprotect password:="cockroach"

Could someone give me the 97 code?

Kenny

works in Xl2000 but notXl97 - help required
 

Hi Kenny,

How are you running this code?

In xl97, if it is run from a commandbutton, you should change the
takefocusonclick property of the commandbutton to False.

---
Regards,
Norman



"N E Body" wrote in message
...
Hi

The following line works in Excel 2000 but gives an error in Excel 97

Sheets("Summary").Unprotect password:="cockroach"

Could someone give me the 97 code?

Kenny