| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Startup Template - Excel 2007/Vista
Good to hear.
Gord On Wed, 23 Dec 2009 10:06:02 -0800, Adri wrote: I created my add-in and it works exactly as needed...thanks. "Gord Dibben" wrote: Good luck with the project. If you want help creating and deleting a button or toolbar or menuitem see Debra Dalgleish's site for some Dave Peterson coding. http://www.contextures.on.ca/xlToolbar02.html Gord On Tue, 22 Dec 2009 13:12:01 -0800, Adri wrote: Thanks for your advice..I found a very good article on creating add-ins, so I'm sure I'll be able to get what I need. Adri "Gord Dibben" wrote: I would create an add-in and store the add-in in a folder that is accessible to all users. Instruct them to load the add-in and keep it loaded. You can code in the add-in to create the button then delete when Excel or add-in is closed. Gord On Tue, 22 Dec 2009 08:27:01 -0800, Adri wrote: Thanks for the info Gord... If I make it an .xlsm, it opens the file when Excel starts, whereas I just want the macro to be available - i.e. to display the customized QAT. I'm going to want to deploy this to everyone on our network, that's why I thought of copying a template to their startup folder at login...I thought an Excel startup template would work like a Word startup template, but apparently not. How would I make the macro always available every time Excel is launched? "Gord Dibben" wrote: Template files *.xltx and *.xltm in XLSTART do not automatically load when Excel starts. *.xlsx and *.xlsm will start automatically. Templates have to be manually loaded or loaded from a shortcut when opening Excel. Gord Dibben MS Excel MVP On Mon, 21 Dec 2009 14:47:01 -0800, Adri wrote: I have a template (.xltm file) containing a macro that is assigned to a button on the QAT for that template. The macro is in ThisWorkbook. When I just open the template, or double-click it from Windows, the button displays and the macros runs correctly. I want the button available all the time so I saved the template in the Excel start folder - C:\Users\xxxx\AppData\Roaming\Microsoft\Excel\XLST ART. When I launch Excel the button does not display, which I take it to mean the template has not loaded. Same result if I put the template in C:\Program Files\Microsoft Office\Office12\XLSTART. Both these startup locations are in Trust CenterTrusted Locations. Does anyone have any idea why the template doesn't load and display the button? Thanks... . . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I open excel template form in a shared file using vista? | Excel Discussion (Misc queries) | |||
| Excel 2007 and Office 2007 stink (so does Vista) | Excel Discussion (Misc queries) | |||
| Excel Template Startup as Workbook | Excel Discussion (Misc queries) | |||
| Excel Template Startup | Setting up and Configuration of Excel | |||
Hybrid Mode
