Grouping objects
SuitedAces wrote:
Does excel see a button from the forms tool bar as part of
ActiveSheet.Shapes ?
Yes. It also treats Command Buttons as Shapes.
Is there a similar way to form groups for controls created with the
Control Toolbox
Yes. You can rename the Command Buttons either in its Properties Sheet
on the Controls ToolBar OR in the Name Box on the left of the Formula
Bar.
So, you can code buttons to hide/show other buttons, be they from
either the Forms or Controls ToolBars.
Ken Johnson
|