Assign macro to WB-specific toolbar button?

[Ian]

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.

 

[Bob Phillips]

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]

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?

 

[Bob Phillips]

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]

So obvious, I don't know why I didn't think of it.

Thanks again, Bob.

 

[Bob Phillips]

Always works better with no control <bg>

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ian]

I think I'm losing it <vbg>

--
Ian
--

Always works better with no control <bg>

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)