Software

Ask something
Discussion Locked

Excel Macros

0 helpful
4 replies

by bytemi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

4 replies

by bytemi

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.

by rdk55

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.

by faradhi

Excel does not have a [b]Default[/b] 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.

This discussion is closed to new replies.