Cycling through controls in Formatting menu (VBA)

[Guest]

Afternoon

Can anyone help ... please !! I am cycling through the controls (using VBA)
in the "Formatting" menu bar, identifying the"Layout" control and actioning
"Execute". The problem I am encountering is that the "Layout" control is held
within the "Add and Remove Buttons" section of the menu bar. If "Layout" is
not selected to appear on the toolbar I am unable to pick up the control and
execute, but if I place the control on the menu bar I can action the control.

Is it possible to get access to the control when it has not been added to
the menu bar (through VBA)? I have looked at the "Enabled = False" option
under the control but it does not appear to recognise the "Layout" control.

Any help would be greatly appreciated.

Regards
Jackie

 

[Shyam Pillai]

Jackie,
Have you tried:
Call Commandbars.FindControl(id:=700).Execute

 

[Guest]

Shyam

Many thanks .... hadn't realised it was that easy. I have been cycling
through controls trying to identify the control I required for hours !!!

Regards
Jackie