ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   button control on Forms toolbar (https://www.excelbanter.com/excel-programming/304707-button-control-forms-toolbar.html)

Greg Goralski

button control on Forms toolbar
 
Due to an inadvertent mouse pad action, I seemed to have
removed the 'button' control from the Forms toolbar.
(note: this is the control used to associate a macro with
a button on an excel worksheet) Does anyone know how to
perform a restore on the Forms toolbar in hopes of
restoring the button control? Any other ideas?

thanks,
-greg




Ron de Bruin

button control on Forms toolbar
 
Hi Greg

Open the forms toolbar fist
ViewToolbars..Customize

On the commands tab choose forms
Now drag the button that is in the list to the right to
your forms toolbar



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Greg Goralski" wrote in message ...
Due to an inadvertent mouse pad action, I seemed to have
removed the 'button' control from the Forms toolbar.
(note: this is the control used to associate a macro with
a button on an excel worksheet) Does anyone know how to
perform a restore on the Forms toolbar in hopes of
restoring the button control? Any other ideas?

thanks,
-greg






Ron de Bruin

button control on Forms toolbar
 
Or with code

Sub test()
Application.CommandBars("Forms").Reset
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Greg Goralski" wrote in message ...
Due to an inadvertent mouse pad action, I seemed to have
removed the 'button' control from the Forms toolbar.
(note: this is the control used to associate a macro with
a button on an excel worksheet) Does anyone know how to
perform a restore on the Forms toolbar in hopes of
restoring the button control? Any other ideas?

thanks,
-greg







All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com