Excel Frequently Used Worksheets

  • Thread starter Thread starter Bill M
  • Start date Start date
B

Bill M

I am looking for a funtion in Excel similar to the MS-
Word menu option "WORK". In Word, this feature keeps a
separate list of frequestly used documents that could be
used a default docs such as a monthly report, letter(s),
project headings/sections, etc. This list is separate
from the standard 1-9 last opened documents.

In Excel I see this feature as a great way to keep a
similar set of spreadsheets that one must access
frequently, but in the recently used list (1-9), could
get rolled off.

I looked through all the commands in Excel and could not
find it at all.
 
As far as I'm aware there's no such function in Excel. (Although I have seen
a fairly cumbersome macro that can do something similarly, which someone may
give you).
What I do is write a macro for each file I want to treat this way and put it
in the File menu.
The code would be something like this which I store in the Personal.xls
workbook:
Sub LoanTapes()
Workbooks.Open Filename:="C:\My Documents\TAPES\loan tapes.xls"
End Sub
(You'll need amend it to put the correct path to the file.)
Rob
 
Not sure of where you found a menu option called "Work".
What version of Word do you use?
Are you talking about templates?
 
I had the same request as you and below is a response
from the community member - "Kieran"
<[email protected]>

QUOTE " I have used the attached add-in to create the
Excel equivalent of the MS Word work menu.

Basically it allows you to create a static list of
favourite files under a new menu item.

From memory it has probelms if the fiels are laready open
by other users, otehr than that it works fine.

Attachment filename: excel_97_2000_workmenu.xla

Download attachment:
http://www.excelforum.com/attachment.php?postid=383355
" END QUOTE


I found this to work just like the word version.
It also works in XP version of excel.
However, just like MS Word, you can't delete individual
files you don't need anymore.

RORY
 
"However, just like MS Word, you can't delete individual
files you don't need anymore."

Not entirely true Rory.
In Word, try (with CAUTION!!) .....
CTRL+ALT+Hyphen.
When you get a thick long hyphen you can delete what you like (even menu
items).
Rob
 
Back
Top