Assign macro to WB-specific toolbar button?
So obvious, I don't know why I didn't think of it.
Thanks again, Bob.
--
Ian
--
"Bob Phillips" wrote in message
...
Just take out the control
Private Sub Workbook_Activate()
Application.CommandBars("CB name").Visible = True
End Sub
Private Sub Workbook_Deactivate()
Application.CommandBars("CB name").Visible = False
End Sub
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Ian" wrote in message
...
Thanks, Bob. This hides the button perfectly. It is the only button on a
custom toolbar. Is it possible to also hide the toolbar, such that it
reappears docked in the same place it was?
--
Ian
--
"Bob Phillips" wrote in message
...
Private Sub Workbook_Activate()
Application.CommandBars("CB name").Controls("button name").Visible =
True
End Sub
Private Sub Workbook_Deactivate()
Application.CommandBars("CB name").Controls("button name").Visible =
False
End Sub
This is ThisWorkbook code module code.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Ian" wrote in message
...
In Excel 2000, s it possible to assign a macro to a toolbar button and
make that toolbar button visible (or active) ONLY when the book
containing the macro is active?
I've written a macro and assigned it to a toolbar button, but the
button is always visible and active.
--
Ian
--
|