Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rafe
 
Posts: n/a
Default Problem Assigning Macros

I am attempting to assign a macro to a button I have created in a worksheet
in Excel 2002. I have worked with other versions of Excel without issue, but
for some reason, when I go to assign a macro to the button I created, there
is no option for me to "Assign Macro". I'm afraid I'm not saavy enough to
write code, so I need this function to operate. I have a major presentation
on Monday and I desperately need some guidance.

Thanks,

Rafe
  #2   Report Post  
LanceB
 
Posts: n/a
Default

use the button from the forms toolbar rather than the one from the control
toollbar.

The "Forms" button asks you to assign it to a macro

"Rafe" wrote:

I am attempting to assign a macro to a button I have created in a worksheet
in Excel 2002. I have worked with other versions of Excel without issue, but
for some reason, when I go to assign a macro to the button I created, there
is no option for me to "Assign Macro". I'm afraid I'm not saavy enough to
write code, so I need this function to operate. I have a major presentation
on Monday and I desperately need some guidance.

Thanks,

Rafe

  #3   Report Post  
bj
 
Posts: n/a
Default

Right click on your button and the assign macro is one of the options.

"Rafe" wrote:

I am attempting to assign a macro to a button I have created in a worksheet
in Excel 2002. I have worked with other versions of Excel without issue, but
for some reason, when I go to assign a macro to the button I created, there
is no option for me to "Assign Macro". I'm afraid I'm not saavy enough to
write code, so I need this function to operate. I have a major presentation
on Monday and I desperately need some guidance.

Thanks,

Rafe

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
assigning macros to buttons or autoshapes John of the new year Excel Worksheet Functions 1 June 10th 05 01:31 AM
Problem with running Macros Mark Alex Excel Discussion (Misc queries) 1 May 17th 05 02:28 PM
Enabling macros Peter M Excel Discussion (Misc queries) 3 February 7th 05 10:57 PM
sorting with macros Sorting in macros Excel Discussion (Misc queries) 1 February 1st 05 09:02 AM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 12:21 AM


All times are GMT +1. The time now is 11:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"