Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2010 - File, New, General Templates

Status
Not open for further replies.
Eprice

Eprice

Technical User
May 6, 2003
209
US
Hi,
We are converting our templates from XP to 2010 for word and excel.
I am trying to create an icon to customize our Quick Access Toolbar to open the templates dialog box to eliminate clicks for the users.
Word has the icon but I cant find it in excel. Using this code will open the dialog box:
Application.Dialogs(xlDialogNew).Show

How do I make this global for all users?
Thanks
Lisa
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
559
mikrom
mikrom
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
JAB_123
  • Locked
  • Question
I want to use an excel file for inp
Replies
3
Views
328
dhookom
dhookom
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
588
huiettcm
huiettcm
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
3K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top