View Single Post
 
Old 12-13-2016, 05:40 PM
geepeeone geepeeone is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2016
Posts: 1
geepeeone is on a distinguished road
Default Here you go

Step 1

Create VBA module for each template (Note: You may want to rename the Macro "F4' with a meaningful name)

i.e.,

Sub MakeItem()
Set newItem = Application.CreateItemFromTemplate("C:\Users\userf irst.userlastname\AppData\Roaming\Microsoft\Templa tes\nameofthefile.oft")
newItem.Display
Set newItem = Nothing
End Sub

Step 2

Create a new button through "Customize Ribbon." Under "Choose commands from" dropdown menu, select the Macro created in step 1 --> Assign icon. Voila! done!
Reply With Quote