Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign a Macro | Excel Discussion (Misc queries) | |||
Assign F1 as a macro? | Excel Discussion (Misc queries) | |||
assign a macro | Excel Discussion (Misc queries) | |||
assign macro | Excel Worksheet Functions | |||
Assign Macro | Excel Discussion (Misc queries) |