Yesterday i worked with 3 different people, who couldnt find a file,
the most recently used file list should have been 100 files long.

I am sure this would be very helpful for many users.

I thought of every time a file is opened writing the file name location
and date to sheet 1 of the personal xls file, then adding a new menu
item that would show those files as a hyperlink list.

BUT, how can i have excel record when a file is opened? can i do from
an event in the personal book?

Help greatly appreciated!

~M

Look at Application Level Events.

A start is Chip Pearson's site

http://www.cpearson.com/excel/appevent.htm

You could put this type of code in the Personal.xls

--
Regards,
Tom Ogilvy

"Mikerosoft" wrote in message
ups.com...
Yesterday i worked with 3 different people, who couldnt find a file,
the most recently used file list should have been 100 files long.

I am sure this would be very helpful for many users.

I thought of every time a file is opened writing the file name location
and date to sheet 1 of the personal xls file, then adding a new menu
item that would show those files as a hyperlink list.

BUT, how can i have excel record when a file is opened? can i do from
an event in the personal book?

Help greatly appreciated!

~M