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
--

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" <(E-Mail Removed)> wrote in message
news:2PzFh.35958$(E-Mail Removed)...
> 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
> --
>
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:2PzFh.35958$(E-Mail Removed)...
>> 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
>> --
>>
>>
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:2yBFh.42954$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:2PzFh.35958$(E-Mail Removed)...
>>> 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
>>> --
>>>
>>>
>>>
>>
>>
>
>

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

Thanks again, Bob.

--
Ian
--
"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:2yBFh.42954$(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:2PzFh.35958$(E-Mail Removed)...
>>>> 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
>>>> --
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:dbCFh.24079$(E-Mail Removed)...
> So obvious, I don't know why I didn't think of it.
>
> Thanks again, Bob.
>
> --
> Ian
> --
> "Bob Phillips" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:2yBFh.42954$(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> 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" <(E-Mail Removed)> wrote in message
>>>> news:2PzFh.35958$(E-Mail Removed)...
>>>>> 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
>>>>> --
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

I think I'm losing it <vbg>

--
Ian
--
"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:dbCFh.24079$(E-Mail Removed)...
>> So obvious, I don't know why I didn't think of it.
>>
>> Thanks again, Bob.
>>
>> --
>> Ian
>> --
>> "Bob Phillips" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:2yBFh.42954$(E-Mail Removed)...
>>>> 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" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> 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" <(E-Mail Removed)> wrote in message
>>>>> news:2PzFh.35958$(E-Mail Removed)...
>>>>>> 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
>>>>>> --
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>