CommandBar Controls
 

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?

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?

CommandBar Controls
 

after typing the dot after controls("New") I did not see FaceId in the drop
down. I looked at other code I had, and I had used it there so I was confused
why. Just thought I was missing something.

thanks

Simon

"Jim Rech" wrote:

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?

CommandBar Controls
 

Simon

It depends on how you reference the control. This:

Application.CommandBars(1).Controls("New")

will not bring up the FaceId because it's referencing the CommandBarControls
collection. That collection can contain different types of controls some of
which do not have the FaceID property. However, if you know that the
control your referencing has a FaceID property, you can use it anyway (as
Jim pointed out).

Dim cb as CommandBarButton
Dim cc as CommandBarControl

cb.FaceID = 123
cc.FaceID = 123

Since cb only references one type of control (that uses FaceID), FaceID will
show up on the popup. On the other hand cc won't show FaceID because it
could be any type of control.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Simon Shaw wrote:
after typing the dot after controls("New") I did not see FaceId in
the drop down. I looked at other code I had, and I had used it there
so I was confused why. Just thought I was missing something.

thanks

Simon

"Jim Rech" wrote:

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?