Hi Hoppermr,

My application works so long as users don't go changing sheet names. Can
anyone help me?

Try changing your code to use the sheet code name instead of the sheet name.
If the user changes the sheet name, the code name remains unaltered.

---
Regards,
Norman



"hoppermr" wrote in message
...
I would like VBA code to protect a worksheet from being RENAMED - pls don't
confuse this and tell me how to protect a worksheet as I already know
that.

My application works so long as users don't go changing sheet names. Can
anyone help me?

Thnx