Deactivate button on criteria

Giganews Newsgroups
Subject: Deactivate button on criteria
Posted by:  Rick Ong (ricko…@singnet.com.sg)
Date: Mon, 20 Oct 2003

I had created a button to run a macro and insert some
value in 2 cells. How can I deactivate the button whenever
the operation is complete, and only re-activating it
provided that the contents in both the cells are cleared
or deleted?

Replies