Results 1 to 13 of 13
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Rockford, Illinois, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Work menu (97/2000)

    Is there a work menu feature in Excel like there is in Word? I have some files that I use frequently and would like to add them to a menu instead of using the recently used file list. Or does someone know of a workaround that would do the same thing?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Work menu (97/2000)

    erh3

    Not being familiar with MS-Word's Work menu, I can't really answer your question, but do you know why VBA was included with the office Applications?

    Its to do what ever the application allows you to do.

    I suggest you build your own toolbar with a dropdown. Each time you save a workbook it will be added to the list, and each time you start MS-Excel it will read the new list and the workbooks will be there.

    Use the Personal.XLS this way it will be there for your any time you use MS-Excel.

    If you need additional help, please let me know.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Work menu (97/2000)

    I don't know of a Work menu for Excel but here's how you can accomplish roughly the same. It takes a little more work but if you use particular files alot, it may be worth it. But only works if you use Internet Explorer

    1. Open up your Favorites folder (usually under the Windows folder). This is where IE stores bookmarks and other things. If you want, create a subfolder under this called something like Excel Work.
    2. Drag a shortcut to the file into the folder of #1. Yep, this has to be done outside Excel.
    3. Go into Excel and go to Tools | Customize dialog and click on the Commands tab. On the left side, find the Web category and on the right find the Favorites command. Drag the Favorites up to your toolbar. Click OK to exit the dialog.

    Now when you click on Favorites, you'll get a drop-down menu. If you created a subfolder in #1, go to that. When you click a shortcut here, it will open the workbook.

    Adv: you can keep as many items here as you want. Unlike Work, they won't be deleted when you reach some magic number (forgot what it is).
    Disadv: in addition to a little more work to set things up, the items won't be deleted when you reach some magic number.

    HTH

    Fred

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Work menu (97/2000)

    Very Nice Tip! <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7DS

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Work menu (97/2000)

    The Favorites Menu tip has one practical disadvantage - if you want to work with two (or more) files simultaneously. Selectoing a file through the favorites menu will automatically close the file that currently has the focus. Naturally, you can navigate back to it (if you've finished with the "new" file) using the web address feature.

    I have some code (from a free add-in) that deliberately duplicates the Word Work Menu in Excel(97/2000). It would need some cleaning up from some subsequent tinkering, but I could post it if anyone is interested.

    HTH
    Gre

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Work menu (97/2000)

    Another item I discovered about the Favorites after thinking about it and trying it. Removes some of the disadvantages.

    1. Create an entry for your Favorites folder in the Send-To menu. This will allow you to send things to your Favorites folder, which I'll use in Step 6.

    2. If you're working with a new workbook, you have to save it first to give it a name (I think this would be true even for the Work menu).

    3. Select any of the File menu items that give you a file dialog (eg, File Open or File Save As). This will get you a listing of files, which is all we care about here.

    4. Find the file you want to add to your favorites. If this is one you just created, for example in Step 2, then the dialog will be in the folder where you put that.

    5. Right click on the file of step 4. On the shortcut menu, choose Create Shortcut. This will create a shortcut to the file and it will appear right next to the real file itself in the file dialog window.

    6. Now right click on the Shortcut. Choose Send To. go to the submenu that opens and click on Favorites. This will send the Shortcut right to Favorites and it won't be in the dialog window anymore.

    7. Close the dialog window.

    SO now you can add your files from within Excel to Favorites. As far as deleting them, you can do that from Excel too. Just open a file dialog window, navigate over to Favorites (eg, may want to set up a shortcut to Favorites in My Documents, assuming your saved files may go into My Documents; it could be anywhere else also or as an alternative such as Desktop). When you get to the Favorites, you can click on the shortcut to be deleted, hit the Delete key and it's gone.

    Unkamunka pointed out something that could be a problem for you - can't have 2 files open at same time if using the Favorites. I played around a little and found some more strange things.

    First, if you have no Workbook open at all - that is, the work area is just a big grey blank area - Favorites won't open your selection. So you at least have to have a blank workbook open.

    Now that you have one thing open (even if only a blank workbook), Seems like Favorites always wants to close something. Kind of supports what Unkamunka pointed out. But see below.

    If the Workbook that was open wasn't saved yet, using Favorites will result in a prompt that asks if you want to save it (because Favorites is going to close it). SO there's your chance to save it. At least this is good.

    I took this 1 step further. I had 2 workbooks open thru the normal approach. Went to open a 3rd thru Favorites. Now it did NOT close any of the open workbooks!

    Maybe this is an odd-even thing but I wasn't going to explore further. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Almost sounds like this should be on the Windows board (BTW, I'm using Windows 98 on this machine).

    HTH.

    Fred

  7. #7
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Work menu (97/2000)

    Sorry - forgot to mention 1 other thing.

    If you open the first file thru your Favorites button, you can open a 2nd file by the regular approach of course. For this, you can use your File Open and navigate to the Favorites folder. If you open the 2nd file thru the File Open, even if it's in the Favorites folder, both files will be open. Just don't use the Favorites button for the 2nd file.

    Fred

  8. #8
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Work menu (97/2000)

    erh3

    Could you take a few minutes of time and tell us what this "Work" Menu is all about?

    I have MS-Word 97 and 2000 and I searched the OLH for "Work Menu" and nothing came up.

    I would appreciate it if you could tell me how to get to it.

    TIA

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  9. #9
    Lounger
    Join Date
    Jan 2001
    Location
    Rockford, Illinois, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Work menu (97/2000)

    I am interested in the code. Thanks in advance.

  10. #10
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Work menu (97/2000)

    The work menu in Word is used to allow quick access to documents that you use regularly. It is added to the menu bar and allows the user to select the document just like selecting any other menu command.

    To use it in Word select Tools>Customize...
    On the Commands tab select Built-in menus in the catagories section and scroll down to Work in the commands section. Click and drag the Work menu onto the menu bar.

    Excel does not include the work menu, but the attached add-in works in the same way as Word's Work menu.

    To delete an item from the Works menu select Tools>Customize... and click and drag the relevant file off the list.

    The add-in was written by Ian Sharpe who works for the UK magazine PC Plus and was included in the December 1999 issue of that magazine. It was designed for Excel 97 or 2000, though it also works with 2002
    Attached Files Attached Files

  11. #11
    Lounger
    Join Date
    Jan 2001
    Location
    Rockford, Illinois, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Work menu (97/2000)

    <P ID="edit" class=small>Edited by WebGenii on 20-Jan-02 14:39.</P>It is just like having a Favorites menu. Check out this article on the Word MVP page. It tells you all you need to know to get started using it.

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/General/WorkMenu.htm>http://www.mvps.org/word/FAQs/General/WorkMenu.htm</A>

    The article is written by Charles Kenyon, who you probably already know. I regularly check his post on recent additions to the MVP Word page. (I would point you to the posting, but I haven't figured out how to do that yet.) This feature is not documented by MS too well. I think I stumbled upon it a couple of years ago and continue to use it in Word. It would be great if the same feature was available in Excel. Alas I have to find an alternative to do the same thing.

    Thanks to all for the help.
    edited to correct link and add hyperlink - WebGenii

  12. #12
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Work menu (97/2000)

    Sorry for the VERY late reply. What I was referring to was the Ian Sharpe add-in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=108795&page=1 &view=collapsed&sb=5&o=0&vc=1#Post108795>posted above by</A> Tony55 (with which I had tinkered). Hopefully, you have now sorted this out.
    Gre

  13. #13
    Lounger
    Join Date
    Jan 2001
    Location
    Rockford, Illinois, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Work menu (97/2000)

    Thanks. I downloaded the add-in and it works like I want it to. I wish MS would have integrated it with Excel like they have with Word.

Posting Permissions

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