Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIDING A BUTTON
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIDING A BUTTON
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIDING A BUTTON
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding cells then a button to show them again | Excel Discussion (Misc queries) | |||
hiding cells then a button to show them again | Excel Discussion (Misc queries) | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
hiding forms button | Excel Discussion (Misc queries) | |||
Hiding A Sheet Command Button With VBA | Excel Programming |