View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default CommandBar Controls

I don't know about recording a macro but I have no problem changing the face
id of a built-in control:

Commandbars("Standard").Controls("New").FaceId=123

Did I misunderstand the problem?
--
Jim Rech
Excel MVP

"Simon Shaw" wrote in message
...
|I have built menus and toolbars for my excel apps so I am familiar with
| creating and setting up controls and buttons for commandbars. Now I am
trying
| to assign a FaceId to an msoControlButton, however this is not working. I
can
| assign FaceId's to buttons that I create, but not to standard ones like
'Save
| As'
|
| When I manually customize a toolbar I can add a control such as 'Save As',
| then change it to default style, then select from one of the pictures.
When I
| try to record this in a macro I do not get any code for the FaceId change.
|
| Ideas?