Thread: HIDING A BUTTON
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default HIDING A BUTTON

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.

--
Regards,
Tom Ogilvy



"Glenn" wrote in message
...
Sorry but I do not understand. Whwere does this go?

"Tom Ogilvy" wrote:

button reference .visible = False

--
Regards,
Tom Ogilvy

"Glenn" wrote in message
...
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