The idea in XL97 seemed to be to supersede the drawing-objects level and its
sub-type collections with Shapes. Fortunately that never quite happened,
however it means there's not much in Help. Button(s) is a sub-type that
refers to Buttons applied from the Forms toolbar.

Dim btns As Buttons
Dim btn As Button

start typing "btn." and/or "btns." for the intellisense.

Could get more by putting some buttons on the sheet, run this
Set btns = ActiveSheet.Buttons
Set btn = btns(1)
Stop ' look in Locals, Alt-v,s

You can also search Button(s) in Object browser F2. On the rt-click menu
tick Show hidden members.

Most of the methods and properties that you'll quickly see from any of the
above three methods are pretty obvious.

Working with these types of objects is often faster than working with the
Shapes collection, and for some thing's less code. Small point, although
you can do For Each btn in btns, it's a bit more reliable to loop by index
in rare situations.

Regards,
Peter T


"Gary''s Student" wrote in message
...
What are the methods and properties associated with the Buttons object?
--
Gary''s Student - gsnu2007xx