Exclude macros from triggering msgbox

[Jamesera27]

I have many formulas in my workbook and I don't want anyone writing over them. Normally they are in protected mode. Sometimes the sheets need to be unprotected leaving the cells with formulas vulnerable to write over by accident. I know how to have a msgbox pop up when a cell with a formula in it is selected. The problem is I have a button which runs several macros. I don't want any msgbox' to pop up when I run the macros. The only time I want the msgbox to appear is when a user unprotected the sheet or workbook and selects a cell with a formula in it. I hope this makes sense. Any help would be appreciated

[TMS]

Define a global Boolean variable. By default, it will have the value False. At the start of each of your macros, set the variable value to True, and at the end, reset it to False. Then use the variable to determine whether or not the MsgBox is displayed.


Regards, TMS

[Jamesera27]

Thanks Trevor, sounds like a great way to solve the problem. I'm not the greatest with excel so i'll search for examples of doing this. Any examples would be appreciated. Thanks again, Jim

[TMS]

You're welcome. Thanks for the rep.

Please Login or Register  to view this content.

Regards,TMS

[Jamesera27]

Outstanding. exactly what i was looking for. Thanks again, Jim

[TMS]

You're welcome.