button control on Forms toolbar

[Greg Goralski]

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


(e-mail address removed)

 

[Ron de Bruin]

Hi Greg

Open the forms toolbar fist
View>Toolbars..Customize

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

 

[Ron de Bruin]

Or with code

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