Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / February 2004

Tip: Looking for answers? Try searching our database.

No "Attach macro" line on CommandButton menu

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David F - 25 Feb 2004 12:00 GMT
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 - 25 Feb 2004 12:45 GMT
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

> With the help of an experienced friend, I recently
> installed Excel 2002(in a Windows 2000 system)and began to
[quoted text clipped - 12 lines]
> access this feature?
> Suggestions much appreciated!
Hilken - 26 Feb 2004 13:48 GMT
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

>-----Original Message-----
>With the help of an experienced friend, I recently
[quoted text clipped - 17 lines]
>Suggestions much appreciated!
>.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.