A Workbook_Open() event cannot be in a standard module. Perhaps that is the
source of your problem.

--

Vasant


"James" wrote in message
...
Thanks Tom.

Unfortunately I'm not using a shortcut key - it's just a straightforward
Sub in a standard code module.

The code is executing perfectly except for unprotect the worksheet.

Any other offers?