Built-in Controls


Application.Commandbars.ExecuteMso

This can only be used to execute built-in commands. It cannot be used with custom commands.

Application.Commandbars.ExecuteMso("Copy") 

Control Identifiers

It can often be a challenge to work out the control IDs (or names) for all the built-in controls.
The (Options > Customise) tab can display the control ids for all the built-in controls.
To see a particular control id select the command and hold your cursor over the button in the list.
The control id is displayed on the tootip:
SS


If you want to use one of the built-in icons but not the default functionality for a button you can set your controls imageMso attribute to be that same control ID.
This eliminates the need to find a controls faceid because the icon has the same name as the control (the control id).


You can download a list of all the control IDs from MSDN.
To help you find the ID of a particular control on any of the built-in tabs you can use the following references:
This workbook contains a list of all the control identifiers for the built-in commands


Office 2013

link - microsoft.com/en-us/download/details.aspx?id=36798 

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext