Results 1 to 4 of 4
  1. #1
    liner
    Guest
    I tried searching for this, but I cannot find it in this site. My searching is either too broad or too restrictive.

    I want to open a document using an Excel template. The only way I find to do it is to use File New, then go to the sidebar that opens up and choose template.

    Is there a command button that will open the templates directly? I think I have gone through the standard commands, but after a while my eyes start to glaze over.

    Or, is there a macro that I can use to do the same thing?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Unfortunately, there is no built-in toolbar button for this, but fortunately you can create one:

    - Create the following macro in your personal macro workbook Personal.xls:

    Code:
    Sub FileNew()
      Application.Dialogs(xlDialogNew).Show
    End Sub
    - Create a custom toolbar button:

    Select Tools | Customize...
    Activate the Commands tab.
    Select Macros in the list of categories on the left.
    Drag Custom button to a convenient location on a toolbar (for example next to the New button on the Standard toolbar).
    Right-click the new button and select Assign macro... from the popup menu.
    Select Personal.xls!FileNew and click OK.
    Right-click the new button again to change its other properties.
    Close the Customize dialog when you're done.

  3. #3
    liner
    Guest
    Thanks Hans.

    As an aside, I bet you have those instructions for custom toolbars on some sort of template. You use them over and over.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='liner' post='794466' date='22-Sep-2009 22:19']As an aside, I bet you have those instructions for custom toolbars on some sort of template. You use them over and over.[/quote]
    Well, no, I wrote them from scratch. (I do have a Word document with some stock answers though)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •