Showing button based on cell result -

[gpeterson82]

I would like to only show a macro button if a particular cell =0. If it >0 I would like the button to be hidden.

Pretty sure this is VBA stuff but I haven't had much luck with what I've seen so far.

I've thought about just having the button invisible and changing the text where the button sits to tell people when to 'click here' (when the cell = 0).

I'm having some issues with getting the button to click though when I set visible=false.

If I set visible=false and I click on the place where the button was I end up clicking into the text box for that cell and the button does nothing.

[Palmetto]

Using an Active-X command button, you could use this code in the worksheet_change event.
Adjust the cell reference as needed.

Please Login or Register  to view this content.