General discussion

Locked

Excel Macros

By bytemi ·
Is there a template that I can create and make it the default on all of my networked machines. Like the Normal.dot in Word?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by faradhi In reply to Excel Macros

http://office.microsoft.com/en-au/assistance/HA010548151033.aspx

Collapse -

by bytemi In reply to

I found this article before posting but I still am unable to locate the default template to modifiy. There has to be a way to share marcos.

Collapse -

by RDK55 In reply to Excel Macros

You should be able to open a new workbook, make your modifications, and then save it to your local XLSTART folder. For networked machines you may have to save it to a common location and have Excel point to that location as your Alternate Startup File Location.

Collapse -

by faradhi In reply to Excel Macros

Excel does not have a Default template. You must make one then store it in the directory the article describes.

So create your macros, go to file --> Save As. Select file type as Template. Save and distribute.

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums