View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Al Holix[_2_] Al Holix[_2_] is offline
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?