Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Cannot assign macro to button (2003)

    I've created a custom toolbar for a user. I've recorded a macro that is suppose to open a template that's on the server. I've created a button on the custom toolbar and tried to assign this macro to the button. The macro was saved in the personal.xls file. But, every time I click on the button, the Assign Macro window opens and even clicking on it, nothing happens. If I go into Tools, Macros, and select the macro and run it, it's fine. What am I doing that's so stupid?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cannot assign macro to button (2003)

    If you go to View- toolbars - customize - commands(tab) and select the toolbar button
    If you press "Assign macro" what name is listed? Is it a macro prefaced with 'personal.xls!' ?

    If not you are not pointing it to the right spot.

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cannot assign macro to button (2003)

    Is your macro listed in the Assign Macro listbox at all???
    Regards,
    Rudi

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: Cannot assign macro to button (2003)

    (I'm in the office at the PC and Excel at the moment).
    I've created a custom toolbar and am trying to place the macro on the toolbar.
    I dragged the Custom Button to the new toolbar and right clicked it. Then, I tried to assign a pre-written macro (that's in the Personal.xls).
    I'm selecting the macro in option for the Personal.xls. But, it doesn't "stick"...
    When I click on the new button on the custom toolbar, I'm thrown back into the window to select the macro again.
    I don't know how to paste an image in the forum...so I'll have to describe the window...it's the Assign Macro window (again) wanting me to pick the macro.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cannot assign macro to button (2003)

    Lets see if we can clear up your problem:
    TO CONFIRM...
    1. You say you have recorded a macro in the Personal Macro Workbook.
    2. The macro does run using any other event to trigger it (except the new toolbar)
    3. The macro is listed in the Assign Macro dialog.
    ACTION STEPS...
    1. Right click the a toolbar and choose customize
    2. In the customize dialog, click the TOOLBARS TAB and choose NEW (to create a new toolbar)
    3. Give the toolbar a name and OK
    4. Click the COMMANDS TAB and scroll down to the category MACROS in the left window.
    5. Select Macros and drag the SMILEY to your new custom toolbar.
    6. Right click on the Smiley on your toolbar.
    7. Choose Assign Macro, and select the Personal macro that should be listed in the list!
    8. Make any other adjustments from the right click menu and choose CLOSE.
    9. Test the button...It should trigger the macro now!

    SEE Attachment for screenshot!

    PS...
    1.To send a screenshot, set up the screen with the components you need, and press the PRINT SCREEN button on your keyboard.
    2. Open any graphic program and select paste from that programs EDIT menu.
    3. Edit the graphic if necessary and save it as a JPEG, PGN, or TIF (JPEG or PNG is best!)
    3. Once saved, click the BROWSE button on a new post and browse to the file to attach it!
    (NB - the file must be less that 100k in size)
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •