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