ExcelBanter - HIDING A BUTTON

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - HIDING A BUTTON (https://www.excelbanter.com/excel-programming/329088-hiding-button.html)

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

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

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

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