+ Reply to Thread
Results 1 to 3 of 3

Maintaining Macro Enabled Templates (XLTM)

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Maintaining Macro Enabled Templates (XLTM)

    I'm new to macro-enabled templates. I have to hit the ground running on this due to circumstances beyond my control (Background detail = I am taking over somebody else's project which is heavily tied to a XLTM.)

    I think I am OK with the general concepts of what a XLTM is and when you would want to use one.

    What I think I need help on is how to best maintain the XLTM template. Essentially I don't want end users able to edit the XLTM. But as the developer/maintainer I need the option to do so. What is a good approach for this?
    Last edited by mc84excel; 10-01-2019 at 11:53 PM.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,336

    Re: New to Macro Enabled Templates (XLTM)

    Your thread title is not really indicative of your actual question - I suggest you reword it to clarify the help you are seeking.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: New to Macro Enabled Templates (XLTM)

    OK, done. (Although I was/am interested in any tips & traps for somebody new to Macro Enabled Templates. The maintenance aspect is more of an advanced additional question)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Workbooks.Open freezes excel...Macro-enabled and not Macro-enabled :(
    By IndesliciveMelon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2018, 05:48 PM
  2. Replies: 2
    Last Post: 12-06-2017, 11:33 AM
  3. Replies: 4
    Last Post: 04-01-2017, 03:41 AM
  4. .xltm into excel file which still contains the macro
    By hahmed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2013, 01:22 AM
  5. Custom File Name At Start-up Using Macro-Enabled Template Format (.XLTM) (VBA)
    By engineerchange in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2012, 08:48 AM
  6. Replies: 3
    Last Post: 09-11-2009, 03:38 AM
  7. [SOLVED] strange behavior excel templates (in comparison word templates)
    By buttie in forum Excel General
    Replies: 0
    Last Post: 01-05-2006, 06:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1