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?
--
John Dean
Oxford

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


"John Dean" wrote in message
...
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?
--
John Dean
Oxford

Maybe...

http://www.dailydoseofexcel.com/arch...avorites-menu/

From Dick Kusleika's Daily Dose of Excel blog.



John Dean wrote:

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?
--
John Dean
Oxford

--

Dave Peterson

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


"John Dean" wrote:

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?
--
John Dean
Oxford

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

remove nospam for email addy!



"Elkar" wrote:

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


"John Dean" wrote:

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?
--
John Dean
Oxford

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, befo=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()

--
David