Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Commandbar frustration. | Excel Programming | |||
commandbar | Excel Programming | |||
commandbar hunt | Excel Programming | |||
Moving CommandBar using VBA or C# | Excel Programming |