Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    570
    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,838
    Thanks
    411
    Thanked 1,570 Times in 1,421 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
    3,233
    Thanks
    154
    Thanked 609 Times in 579 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
    570
    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
  •