+ Reply to Thread
Results 1 to 3 of 3

How to create a master template

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-06-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    261

    How to create a master template

    I would like to create a template that when you edit something it cannot change the original. It must prompt you to save it as a separate file.

    What are the different methods of achieving this?
    Last edited by kyber; 08-13-2021 at 09:32 AM.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: How to create a master template

    The simplest method is to save your file as an Excel template (.xltx). When this is double-clicked, it opens a new file with everything in the template, but when you press Save it will prompt for a new filename.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: How to create a master template

    Thanks for the rep and for marking the thread as Solved.

+ 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. [SOLVED] Create Master Template that uploads
    By d7882 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-05-2018, 08:27 AM
  2. VBA - Loop Master template and create Regional Workbooks
    By jstenhouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2015, 10:11 AM
  3. Master sheet into template, copy template to sheets named after master column.
    By M4R1N3R in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2015, 12:24 PM
  4. Replies: 3
    Last Post: 09-04-2013, 11:55 PM
  5. Replies: 0
    Last Post: 03-20-2012, 12:26 AM
  6. Create a pivot table template/master copy?
    By Monique Rebanks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2010, 04:04 PM
  7. [SOLVED] create a master worksheet template
    By Derek in forum Excel General
    Replies: 0
    Last Post: 01-10-2006, 11:45 AM

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