Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extra Spreadsheet starts when Macro activated (excel 2003)

    I have written a macro to open up a specific Excel file. I added an icon to the tool bar and associated it with my macro. This has been installed on a number of machines and it works; but on one machine a second excel file always opens first and then the file that the macro points to is opened.
    What might be a possible explanation for this?
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Extra Spreadsheet starts when Macro activated (excel 2003)

    Is the second workbook the one that contains the macro?

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extra Spreadsheet starts when Macro activated

    I think that you made a copy of the original book that contains the macro. You created a button in a sheet that activates a macro, then you possibly copied the sheet and also the macro, but the button remained assigned to the macro of the original book.

    Reassign the macro of the button to the macro that contains the copy.

    Regards

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extra Spreadsheet starts when Macro activated (excel 2003)

    The Macro is in Personal.xls and is executed from a custom icon on the tool bar
    I do not completely follow what Servando is saying. Since I did not install Personal.xls; I am going to delete the file and reinstall myself as I now think that the initial installation got messed up.
    Thank you for the suggestions

Posting Permissions

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