Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Open Worksheet in Toolbar

    I work with many dozens of worksheets so the nine listed on the File menu (Excel 2003) changes all the time. However, there are three that I go back to over-and-over. Is there an easy way to put buttons on a toolbar to open these three? There appears to be nothing like NORMAL.DOT with Word to save a macro in for reuse.


    Ronny
    Ronny Richardson

  2. #2
    5 Star Lounger RussB's Avatar
    Join Date
    Dec 2009
    Location
    Grand Rapids, Michigan
    Posts
    803
    Thanks
    10
    Thanked 50 Times in 49 Posts
    If you use Win 7, or maybe ?Vista? you can 'Pin" them to the top of the TaskBar icon.
    Do you "Believe"? Do you vote? Please Read:
    LEARN something today so you can TEACH something tomorrow.
    DETAIL in your question promotes DETAIL in my answer.
    Dominus Vobiscum <))>(

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Ronny,

    You can create your own menu with buttons for these workbooks and then display the menu on the standard toolbar as a button. Excel will remember your changes.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Have you thought about using a "workspace" file?
    When you open a workspace file (workspace file: A file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings. A workspace file doesn't contain the workbooks themselves.), Microsoft Excel opens each workbook saved in the workspace.
    • Open the workbooks you want to save in a workspace.
    • Size and arrange the workbook windows as you want them to appear when you open the workspace.
    • On the File menu, click Save Workspace.
    • In the File name box, type a name for the workspace file.
    zeddy

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post
    I'm still using XP. University has not upgraded.


    Ronny
    Ronny Richardson

Posting Permissions

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