HIDING A BUTTON

[Guest]

I HAVE BUILT A WORKSHEET THAT HAS SEVERAL BUTTONS TO PRESS TO START PRINTING
OTHER WORKSHEETS. WHAT I NEED HELP WITH IS:

Hiding the buttons until a particular cell within the worksheet would be
true or equal to a certain value. How do you hide the button.
Thanks,
Glenn

 

[Tom Ogilvy]

button reference .visible = False

 

[Guest]

Sorry but I do not understand. Whwere does this go?

 

[Tom Ogilvy]

It's your application. It would go in whatever code fires at the
appropriate time for when you want this to happen and it would be adjusted
to refer to the specific button (button from forms toolbar? commandbutton
from control toolbox toolbar).

How does the cell value change to true or from true. If with a formula,
then you can put it in the calculate event for that sheet.

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on events.