Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Template (Excel 2000)

    I have created a template in Excel for a form to be completed on line. I have created several macros and have placed them as a button on a customized toolbar. The macros have been saved in the current template workbook. However, when I try to send this template, via e-mail, to another computer, the customized toolbar is not included when the document is opened. Is there any way to accomplish this?

  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: Excel Template (Excel 2000)

    Write macros to create the custom menu "on the fly" when the Template is opened and delete the custom menu when the Template is closed. A bit of work but worth it.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2000)

    The custom toolbar is stored in the .xlb file, not in the template. The best way to do what you want is to write code in the Open Event routine to create the custom tool bar when the template is used to create a new workbook. You should probably also be nice and remove the custom toolbar when the workbook is closed. You could also use the Workbook Activate/Deactivate event routines if you don't want the custom toolbar when the user switches between multiple open workbooks.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2000)

    Thanks for the help. I'll give it a try. Would there be a problem if I were to just copy my .xlb file to the user's computer?

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2000)

    Several problems with just copying the .xlb file.

    1- You would have to find where to put it (the location varies with different versions of Office and Windows).

    2- After you get it copied to the right place, you have to double click on it before Excel recognized that it has the new file.

    3- If the user has customized his own command bars, you will clobber them, and probably have an unhappy user.
    Legare Coleman

  6. #6
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2000)

    You are s-o-o-o right! That is not an option!

  7. #7
    New Lounger
    Join Date
    Jul 2001
    Location
    Neustadt/Wstr., Rheinland-Pfalz, Germany
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2000)

    Hi Legare,

    please excuse my direct post to you, but I've a similar great problem with the custom/command bars and XLB-Files... <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    Do you have any idea to solve this 'similar' problem, I've posted...

    Post-No.: 112023
    Title: network-behavior of Excel.xlb unlike username8.xlb (W2K SP2, Off2K SP2) Excel
    Date: 29-Jan-02 15:33

    With regards

    Axel Heimann

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Template (Excel 2000)

    Sorry, I don't know anything about setting up Excel like you want to do.
    Legare Coleman

Posting Permissions

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