If range is 1 then pop up a message box and close the macro

[debbiesh]

Hello again! I have a simple question. I have a macro that when a button is clicked, a message will pop up asking if the file is saved. If so, then a range in that sheet changes from 0 to 1 and the macros continues.

What I need now is, if the button is clicked while the range is 1, a message will pop up saying it can't be done and they click OK to close the message.

This is what I have --

Please Login or Register  to view this content.

Can someone help? Thanks much!

[Tinbendr]

Just add an Else

Please Login or Register  to view this content.

[debbiesh]

That's it! That's exactly what I needed. Thanks much. (Told ya it would be simple lol)