worksheet protect and macros

Hi,

Protecting a worksheet shouldn't make it inaccessible. What is the code you are using to protect the worksheet? It should be something like

Sheets("CALC").Protect Password:="YourPassword"

Also, can you manually click on the worksheet to select it after your VBA has protected it?

Hope this helps