Using Existing Template In Microsoft Excel 2011 For Mac

Posted on
A template in microsoft excel 2016 basics

Test to be sure Excel is using the template when new workbooks are created; I tested this with Excel 2011 and Excel 2016 installed on the same Mac in May 2016, and both used the same template as expected. Template for new sheets. A workbook template controls the look and layout of sheets already in the workbook, but not new sheets.

Existing

How to Install a Template Article contributed by NOTE: This article is due for revision. While most of the content remains valid, you will find some of it out of date (especially as regards Word 2004). In a strict technical sense you do not have to 'install' Word templates, because they will work from anywhere on your hard disk. However, if you do not place them in the correct folder, the security warnings will make your life a misery, and you will continually have to navigate to the template when you want to use items from it. This article assumes you have read the whole of the Word Help topic 'About Templates'. In this context, a Template and an Add-in are often the same thing.

However, application developers can produce Add-ins which are compiled programs, not templates. Many third-party applications such as scanner or fax applications include these. If you have a template that contains macros or other customizations such as toolbars, it works better from some locations than others.

To use a template, Word must load it. For more information, read the Word Help topic 'About loading and unloading templates and add-in programs'. This article contains four procedures: • • • • Word contains the Visual Basic for Applications scripting language (VBA). Label design software for mac. Excel VBA is a very powerful interpreted or compiled scripting language similar to AppleScript. Unfortunately, with this power comes the ability to do great damage; it is this language that the majority of the viruses you hear about are written in. So Word has now acquired some fairly tough protection measures to avoid attacks from within.

These measures make it very difficult to use templates unless they are in a 'trusted' location. There are two trusted locations; your Word User Templates folder, and your Word Startup folder. By default, your User Templates folder is in /Applications/Microsoft Office X/Templates. By default, your Startup folder is in /Applications/Microsoft Office X/Office/Startup/Word. These locations were a convenient place for Microsoft to install templates, because it knows that if it can get permission to install the application, it has permission to write to this location.

However, experienced users don't leave them there for long; it would be a bit like putting a sign on the front of your house saying 'The safe is in the upstairs front bedroom.' Not only does any user on your computer have access to these locations, but all virus writers looking to infect you can guess where your jewelry box is. Your templates are a very valuable resource (or they soon will be.). Any long-term power user of Word has hundreds or thousands of hours of development locked up in their templates. We suggest that you move your Templates folder, pronto.