No "Attach macro" line on CommandButton menu

[David F]

With the help of an experienced friend, I recently
installed Excel 2002(in a Windows 2000 system)and began to
use the macro and VBA features, and have experienced a
difficulty that makes these features much harder to use.

On my system, attachment of macros to command buttons
cannot be done in the manner described in the Excel Help
instructions (i.e. right click on the command button
sizing handles and enter the macro name in the "attach
macro" space of the menu. On my system, "CommandButton
Object-Edit" and "View Code" appear, but no "attach macro"
menu entry appears at all.

My friend is mystified, as he has found this convenient
feature to work consistently on several Excel versions he
has used over the years. What's wrong, and how can I
access this feature?

Suggestions much appreciated!

 

[Jim Cone]

David,

There are two types of "Buttons" available for use on a spreadsheet.
1. From View | Toolbars | Control Toolbox - initial button caption is
'CommandButton x'.
2. From View | Toolbars | Forms - initial button captions is 'Button x'.

You are looking for #2.
(my preference for buttons on a spreadsheet)

Regards,
Jim Cone
San Francisco, CA

 

[Hilken]

Another useful "button" is a text box. Enter text and/or
graphic and format as desired. Then right click on the
side of the text box so the sizing handle circles appear
and then right click in the grey area and choose "assign
macro" from the popup menu. Deslect print pbject to print
sheet(portion) without it. There are moving and sizing
options also.
I use macros a lot for saving with backup. by saving the
macro to the specific work book and assigning it to text
box I avoid accidentally saving one file to another. Also,
very usefull for navigation to specific worksheet or work
sheet area in a many sheeted file to an index or list
or ???

Enjoy