How To Save Workbook As Macro Enabled Template
How to create a Macro-enabled template in Excel?
Supposing you add a VBA macro for a workbook, now you want to save it as a template. With normally method to save as template, information technology will pop up a warning dialog box, see screen shot below. Actually, nosotros can hands save this workbook as a Macro-enabled template.
- Salvage current workbook as a macro-enabled template
- Alter the default save format as macro-enable templates
- Save option equally mini template (AutoText entry, remaining cell formats and formulas) for reusing in future
-
Relieve current workbook every bit a macro-enabled template
To save a workbook with VBA macro as template, you can do equally post-obit:
1. Click the File > Save > Computer > Browse.
ii. In the coming Relieve As dialog box, enter a name for this workbook in the File name box, and click the Save every bit type box and select Excel Macro-Enabled Template (*.xltm) from drib down list.
Note: When you lot specify workbook blazon as Excel Macro-Enabled Template (*.xltm), it will open up the default salve location of templates automatically.
iii. Click the Salve button.
Up to present, you take saved the workbook with VBA macros as a macro-enabled template already.
Modify the default save format equally macro-enable template
Really, we can change the default save format and relieve all workbooks as macro-enable templates automatically. Please do as follows:
one. Click File > Options.
2. In the opening Excel Options dialog box, please click Salvage in the left bar, cull Excel Macro-Enable Template (*.xltm) from the Save files in this format drop downwardly list in the Relieve workbooks department. See screenshot:
iii. Click the OK push.
From now all, whatsoever workbook will exist saved as macro-enabled template automatically when you clicking File > Save.
Relieve range every bit mini template (AutoText entry, remaining jail cell formats and formulas) for reusing in future
Usually Microsoft Excel saves the whole workbook equally a personal template. Merely, sometimes you may just demand to reuse a certain pick frequently. Comparison to salvage the entire workbook every bit template, Kutools for Excel provides a cute workaround of AutoText utility to save the selected range equally an AutoText entry, which can remain the cell formats and formulas in the range. And and then yous will reuse this range with only ane click. Total Feature Free Trial xxx-day!
Related articles:
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Bug, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and annihilation that you accept used before; Encrypt Cells with countersign; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Foreclose Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Observe and Fuzzy Observe in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove past Position, Remove Infinite; Create and Print Paging Subtotals; Convert Betwixt Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/24-hour interval, frequency and more; Special Filter past bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on primal columns; Split Data into Multiple Sheets; Batch Catechumen xls, xlsx and PDF...
- More than 300 powerful features. Supports Function/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organisation. Full features 30-day free trial. 60-day money dorsum guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
How To Save Workbook As Macro Enabled Template,
Source: https://www.extendoffice.com/documents/excel/2406-excel-template-macro-enabled.html
Posted by: janousekthearly.blogspot.com
0 Response to "How To Save Workbook As Macro Enabled Template"
Post a Comment