Regularly used files

[John Dean]

Is there any equivalent in Excel to the "Work" menu in Word in the "Built in
Menus" option in the Customise dialogue?
I'd like to be able to attach some worksheets I use regularly to the menu so
I can open them with one click, as you can do with documents on Word using
the Work menu.
I don't want to add them to XLStart because I don't use them *that* often.
Obviously, they stay in the "Recently used files" option on the File menu
but eventually something will knock them off and I'd like a quick link
option.
Any ideas?

 

[Peo Sjoblom]

No, I am afraid not. At least not built in. There might be 3rd party add-ins
that will provide this but I don't know of any


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Dave Peterson]

Maybe...

http://www.dailydoseofexcel.com/archives/2004/12/07/favorites-menu/

From Dick Kusleika's Daily Dose of Excel blog.

 

[Guest]

You may already be aware of this, but the Recently Used Files list can be
expanded to contain up to 9 files. Excel usually defaults to 4 on this list.

Tools --> Options --> General Tab

Change the "Recently Used Files" number to 9.

HTH,
Elkar

 

[Guest]

put some shortcuts on the desktop or on the status? bar right at the bottom
of your scren

 

[David]

I maintain the following in my Personal.xls file:

Private Sub OpenTheFile()
With Application.CommandBars.ActionControl
Workbooks.Open "C:\DATA\EXCEL\" & .Caption
End With
End Sub

Private Sub AddMenu()
Dim vFile, vFiles
vFiles = Array("MyCheckBook", "DT Biweekly Timesheet", "Who_Ate", "GFS
Inventory", "TimeSheet", "Class Utilization", "Daily Signups")
With Application.CommandBars("Worksheet Menu Bar")
With .Controls.Add(msoControlPopup, before:=2, temporary:=False)
..Caption = "D&aily Files"
For Each vFile In vFiles
With .Controls.Add(msoControlButton)
..Caption = vFile
..OnAction = "OpenTheFile"
End With
Next
End With
End With
End Sub

When I want to change the file list, I edit the vFiles list, remove the
current menu by dragging it off the menu bar while pressing the Alt key and
rerun AddMenu()