Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Distributing a Toolbar Button and Macro to users (Excel 2000 / 97)

    Hi guys,
    I've done this before in Word by modifying our standard normal.dot and distributing it to the users PC's. But I'm sad to say I'm stumped on how to do it in Excel. Is there an equivalent to normal.dot? I've seen there is the add-ins and xlstart directories but I don't seem to be able to make it happen by putting files in there - I'm guessing I'm missing something obvious..

    Essentially I have two issues.
    1. I have written a macro and assigned it to a toolbar button on my PC. However when I click the button it attempts to open the file with the macro in it and prompts to enable or disable the macros in the 'new file' it is opening.. I'm guessing this would go away if I could store the macro in some form of 'default user environment' or perhaps tell excel the file is safe? (as its seems fairly unprofessional to make the users enable the macros each time) <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    2. How can I distribute this toolbar change and the related macro to other PCs on the network so that by default this new toolbar button will be available to them when they start Excel.

    Thanks in advance for any assistance .. and please let the solution be not too simple so I don't feel like a complete dolt <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Cheers,
    Steve.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Distributing a Toolbar Button and Macro to users (Excel 2000 / 97)

    You could distribute the macro in Personal.xls including WorkBook_Open event code to insert the toolbar button in the user's menus if the button does not exist. See the later parts of <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=60552>this</A> thread for some advice from MVP Brooke on modifying Excel toolbars and buttons.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    New Lounger
    Join Date
    Sep 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Distributing a Toolbar Button and Macro to users (Excel 2000 / 97)

    Thanks for the quick response John

    I started searching through the 22 odd pages of Excel messages but decided to save some time at that point in the hopes someone knew..

    Kind Regards,
    Steve.

Posting Permissions

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