Regularly used files

  • Thread starter Thread starter John Dean
  • Start date Start date
J

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?
 
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
 
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()
 
Back
Top