View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson[_4_] Greg Wilson[_4_] is offline
external usenet poster
 
Posts: 218
Default Names of macros for toolbar buttons

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/

.