Modify Excel 2013 Main template

Folks,
I would like to be able to modify Excel's new workbook template that opens as Book1 to add a module that I would like available every time a new workbook opens?
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wilder1626Commented:
Hi fh_freese

Yes you can. For this, you need to create an Excel Add-in.
Not to complicated.

I will guide on all the steps.

Step 1:
Open a new excel file, Press Alt+F11 to open the Visual Basic Editor, and then click Insert and select Module. see below picture. Then paste the below code.
Option Explicit
Function GetFormula(x As Range) As String
GetFormula = x.Formula
End Function

Open in new window

insert function
Step 2:
You need to save this workbook as: Excel Add-In.
Save the file with name as:  GetFormula
save it also under your document, a place you will remember.
save as excel add in
Step 3:
Now it's time to add the new add-in GetFormula to all new Excel file you will open as a default add-in.

Open a new excel file, Go into File / Option / Add-Ins / In the Manage field  select Excel Add-ins and then, click Go...
excel add in selection
Step 4:
Search for you  GetFormula Excel add ins file you created at step 2.
Follow the steps 1 to 3 in below picture and then click OK.
Make sure to check the GetFormula  before you click OK.
find add in.

Step 5:
Close excel without saving and re open it.
Press Alt+F11 to open the Visual Basic Editor, and see if your module is showing for your  GetFormula .

You have now made  GetFormula be a default module to all excel file.

You can always remove it if you don't want it anymore. Just go back to step 4 and uncheck  GetFormula . This will remove it from the default Add-ins.

Let me know if this is what you needed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
There you go - thanks a lot
0
Frank FreeseAuthor Commented:
great job
Thank you very much
0
Wilder1626Commented:
I glad i was able to help. Let me know if you need any help. :)
0
Frank FreeseAuthor Commented:
I appreciate all the EE help. Again, thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.