+ Reply to Thread
Results 1 to 2 of 2

macro button to save as macro excel template

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    844

    macro button to save as macro excel template

    hi, want a macro to save as a template.
    Basically, to create a button, and a sub to save it as a template when changes are made.
    currently, I have to go to file>save as> excel macro enable template.
    but its too complicated for my helper to learn. so I would like if its possible to make a button and have him click it.
    thank you.

  2. #2
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    844

    Re: macro button to save as macro excel template

    ok, so I recorded a macro:

    Please Login or Register  to view this content.
    but each one, ask me it tells me that a 'file already exist, do you want to replace it" ? how can I over ride that?

+ 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. Excel Not Responding after running Save and Close Macro Button
    By mangesh.mehendale in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-25-2016, 08:25 AM
  2. Save Macro Template on a network drive as Excel file using a cell value as the name
    By rjagain62 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2014, 03:21 PM
  3. Macro to 'save as' a template in the next month folder
    By shikano53 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2014, 06:17 PM
  4. Macro button to save file in excel, format of excel
    By sunshne900 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2013, 02:40 PM
  5. 'Save As' Macro button for a selection of an excel sheet- also as a pdf
    By shootingstarz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2012, 08:38 PM
  6. Using Macro Button With a Template
    By DCSwearingen in forum Excel General
    Replies: 0
    Last Post: 04-30-2007, 11:17 AM
  7. don't save macro results in template
    By Kate in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2006, 04:15 PM

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