Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Vancouver, Br. Columbia
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a template (.xltm file) containing a macro that is assigned to a
    button on the QAT for that template. The macro is in ThisWorkbook.

    When I just open the template, or double-click it from Windows, the button
    displays and the macros runs correctly.

    I want the button available all the time so I saved the template in the
    Excel start folder - C:\Users\xxxx\AppData\Roaming\Microsoft\Excel\XLST ART.
    When I launch Excel the button does not display, which I take it to mean the
    template has not loaded. Same result if I put the template in C:\Program
    Files\Microsoft Office\Office12\XLSTART. Both these startup locations are in
    Trust Center>Trusted Locations.

    Does anyone have any idea why the template doesn't load and display the
    button?

    Thanks...

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you want the macro available all the time, why not put it into the Personal Macro Workbook rather than a template?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Jun 2001
    Location
    Vancouver, Br. Columbia
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I need to deploy it to everyone on the network, so I thought a startup template would be the best way to go...we can just copy the file to everyone's Excel startup folder at next login.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You should either create an add-in that everyone can use or use an xlsm file and distribute that. Excel ignores templates (other than the special 'Book' and 'Sheet' ones) in the XLSTART directories).
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    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
    If you choose to go the "Add-in" route, you may want to check out MS MVP Jan Karel Pieterse article
    http://www.jkp-ads.com/articles/DistributeMacro00.asp

    Steve

  6. #6
    Star Lounger
    Join Date
    Jun 2001
    Location
    Vancouver, Br. Columbia
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the info Steve & Rory...I'll look into that...I thought Excel would work the same as Word as regards startup templates, but obviously not :-)

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Templates in Excel are completely different from Word.
    An Excel template is nothing more than a blueprint for a new copy of itself and all relation to the template is lost as soon as a fresh "copy" of a template is made.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Star Lounger
    Join Date
    Jun 2001
    Location
    Vancouver, Br. Columbia
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm reading your article about creating addins, posted above...it's extremely helpful...thank you!

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You're welcome! Post here if you have any questions.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    Star Lounger
    Join Date
    Jun 2001
    Location
    Vancouver, Br. Columbia
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have created my add-in and it works exactly as needed...I learned lots from your tutorial...thanks again.

Posting Permissions

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