View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default 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