Thanks for your reply Mike. Yes they are in the same mod. However, everything
seemed to right itself once Excel was completely shut down and re-opened. A
bit weird though. Thanks anyway
Regards, Brett

"Mike" wrote:

Are these Subs in the same Mod?

"Brettjg" wrote:

I have set up a private sub in a worksheet that activates a couple of other
macros. Everything was working perfectly, until I protected the sheet. This
of course caused the macro to crash as you would expect, but now after
unprotecting the sheet, the private subs will never activate.

Can someone please advise? Thankyou, Brett