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!
|