These are built-in controls. They do not have VBA macros
assigned to them but instead have built-in functionality.
Excel supports assigning VBA macros to these controls in
the normal manner. To reverse this you can "Reset" either
the specific control or the entire tool bar.
To reset, for example, the Standard tool bar:
1) Right click the tool bar
2) Select Customize (bottom of list)
3) Select the Toolbars tab
4) Select the Standard tool bar from the list
5) Click the Reset button
Alternatvely, run the code:
Application.CommandBars("Standard").Reset
To reset a specific control, for example, the Copy control
on the Standard tool bar, run this code:
With Application.CommandBars("Standard")
.Controls("&Copy").Reset
End With
Regards,
Greg
-----Original Message-----
Where can I find the names of the macros for the buttons
on the standard
or any other toolbar? I have written a macro which I
would like to
assign to the 'Copy' button but I would like to be able
to reverse it
if I run into problems.
---
Message posted from http://www.ExcelForum.com/
.