Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mike@Becketts
 
Posts: n/a
Default Assign Macro to button in Excel doesnt work Any ideas?

I have followed the instructions in help but when I get to step 3 "right
click to bring up shortcut menu & enter Assign Macro" the assign macro"
option does not appear!! Any Ideas
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Mike

can you see assign macro - but it is greyed out? or is it not an option at
all?

if it is greyed out you'll notice around the button little diagonal lines,
click on these and they should go furryish .. now try right mouse clicking.

if the option is not there at all, please post back letting us know how you
created the button.

Cheers
JulieD

"Mike@Becketts" wrote in message
...
I have followed the instructions in help but when I get to step 3 "right
click to bring up shortcut menu & enter Assign Macro" the assign macro"
option does not appear!! Any Ideas



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

There are two different buttons you can place on a worksheet.

One is called a commandbutton and it's from the control toolbox toolbar.

The other is a button from the Forms toolbar.

I'm guessing you used the commandbutton from the control toolbox toolbar. Try
deleting that button and adding a button from the Forms toolbar.



Mike@Becketts wrote:

I have followed the instructions in help but when I get to step 3 "right
click to bring up shortcut menu & enter Assign Macro" the assign macro"
option does not appear!! Any Ideas


--

Dave Peterson
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
Macro not working with Excel 2003 Fernando Gomez Excel Discussion (Misc queries) 1 December 16th 04 12:19 AM
Record Macro Relative does not work? lbbss Excel Discussion (Misc queries) 3 December 13th 04 08:43 PM
Record Macro Relative does not work? lbbss Excel Discussion (Misc queries) 1 December 13th 04 07:55 PM
assign a macro to a control button ewan72 Excel Discussion (Misc queries) 1 December 3rd 04 02:04 PM
How do I setup a spin button in excel Andy K Excel Discussion (Misc queries) 1 November 26th 04 09:08 PM


All times are GMT +1. The time now is 05:43 PM.

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"