Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Assign Macro Dialog Box

I have created a button that I want to assign a macro to. I am fairly certain
I have created the right type of button, and the 'Assign Macro...' option is
avaliable on the drop down menu when I'm customizing the button. However,
once I select the 'Assign Macro...' option - nothing happens whatsoever.

The same lack of action happens when I use the 'Modify Selection' button in
the Customize dialog box.

My office has just udpate the Office suite to 2003.

Any help?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default Assign Macro Dialog Box

Hi Al,

I can't replicate your first problem so can't help there. Perhaps someone
else can.

The second problem: You can only select Modify Selection if you select a
button on one of the active toolbars first.

Regards,

OssieMac

"Al Holix" wrote:

I have created a button that I want to assign a macro to. I am fairly certain
I have created the right type of button, and the 'Assign Macro...' option is
avaliable on the drop down menu when I'm customizing the button. However,
once I select the 'Assign Macro...' option - nothing happens whatsoever.

The same lack of action happens when I use the 'Modify Selection' button in
the Customize dialog box.

My office has just udpate the Office suite to 2003.

Any help?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default Assign Macro Dialog Box

Hi Al,

I can't replicate your first problem so can't help with it. Perhaps some
else knows the answer.

The second problem: You can only select Modify Selection if you select a
button on one of the active tool bars first.

I initially had a problem posting this so my apologies if you get it twice.

Regards,

OssieMac



"Al Holix" wrote:

I have created a button that I want to assign a macro to. I am fairly certain
I have created the right type of button, and the 'Assign Macro...' option is
avaliable on the drop down menu when I'm customizing the button. However,
once I select the 'Assign Macro...' option - nothing happens whatsoever.

The same lack of action happens when I use the 'Modify Selection' button in
the Customize dialog box.

My office has just udpate the Office suite to 2003.

Any help?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Assign Macro Dialog Box

No no... I mean that the Assign Macro option isn't working when accessed from
the Modify Selection button either. For some reason its not accepting that
'Assign Macro' is actually an option!

"OssieMac" wrote:

Hi Al,

I can't replicate your first problem so can't help there. Perhaps someone
else can.

The second problem: You can only select Modify Selection if you select a
button on one of the active toolbars first.

Regards,

OssieMac

"Al Holix" wrote:

I have created a button that I want to assign a macro to. I am fairly certain
I have created the right type of button, and the 'Assign Macro...' option is
avaliable on the drop down menu when I'm customizing the button. However,
once I select the 'Assign Macro...' option - nothing happens whatsoever.

The same lack of action happens when I use the 'Modify Selection' button in
the Customize dialog box.

My office has just udpate the Office suite to 2003.

Any help?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default Assign Macro Dialog Box

My apologies Al. I misunderstood your question. Anyway I can't replicate the
problem so can't help.

Regards,

OssieMac

"Al Holix" wrote:

No no... I mean that the Assign Macro option isn't working when accessed from
the Modify Selection button either. For some reason its not accepting that
'Assign Macro' is actually an option!

"OssieMac" wrote:

Hi Al,

I can't replicate your first problem so can't help there. Perhaps someone
else can.

The second problem: You can only select Modify Selection if you select a
button on one of the active toolbars first.

Regards,

OssieMac

"Al Holix" wrote:

I have created a button that I want to assign a macro to. I am fairly certain
I have created the right type of button, and the 'Assign Macro...' option is
avaliable on the drop down menu when I'm customizing the button. However,
once I select the 'Assign Macro...' option - nothing happens whatsoever.

The same lack of action happens when I use the 'Modify Selection' button in
the Customize dialog box.

My office has just udpate the Office suite to 2003.

Any help?



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Assign Macro Dialog Box

hi,
from your post, i suspect your problem may be "I am fairly certain i have
created the right type of button."
there is only one icon button you can assign a macro to and that is the
smiley face button. you can assign macros to built in icons but they already
have built in micro soft macros assign to them. how did you create this
button? more detail please.

regards
FSt1

"Al Holix" wrote:

I have created a button that I want to assign a macro to. I am fairly certain
I have created the right type of button, and the 'Assign Macro...' option is
avaliable on the drop down menu when I'm customizing the button. However,
once I select the 'Assign Macro...' option - nothing happens whatsoever.

The same lack of action happens when I use the 'Modify Selection' button in
the Customize dialog box.

My office has just udpate the Office suite to 2003.

Any help?

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Assign Macro Dialog Box

I double clicked on empty space in the toolbar to open the Customize dialog
box, then in the Commands tab I selected Macros from the 'Categories' window
and dragged the Smiley Face 'Custom Button' from the 'Commands' window into
the toolbar. I have done this just now to double check - and I still cannot
get any response when I select 'Assign Macro...' from the drop-down menu.

If it helps - I have no trouble Assigning a Hyperlink. And I can run macros
the old fashioned way no problems.

Thanks for the help.

"FSt1" wrote:

hi,
from your post, i suspect your problem may be "I am fairly certain i have
created the right type of button."
there is only one icon button you can assign a macro to and that is the
smiley face button. you can assign macros to built in icons but they already
have built in micro soft macros assign to them. how did you create this
button? more detail please.

regards
FSt1

"Al Holix" wrote:

I have created a button that I want to assign a macro to. I am fairly certain
I have created the right type of button, and the 'Assign Macro...' option is
avaliable on the drop down menu when I'm customizing the button. However,
once I select the 'Assign Macro...' option - nothing happens whatsoever.

The same lack of action happens when I use the 'Modify Selection' button in
the Customize dialog box.

My office has just udpate the Office suite to 2003.

Any help?

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
Assign a Macro The Rook[_2_] Excel Discussion (Misc queries) 5 February 19th 07 06:53 PM
Assign F1 as a macro? Ryk Excel Discussion (Misc queries) 7 October 17th 06 01:12 AM
assign a macro daidipya Excel Discussion (Misc queries) 4 May 30th 06 02:51 PM
assign macro PH NEWS Excel Worksheet Functions 2 February 28th 06 02:17 PM
Assign Macro James Hamilton Excel Discussion (Misc queries) 2 November 2nd 05 10:56 PM


All times are GMT +1. The time now is 10:10 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"