Using Excel 2002...

Is there any way to remove files from this list other than waiting for
them to be replaced over time?

You could remove then. Here is code showing how to get at it

Dim i As Long
For i = 0 To Application.RecentFiles.Count
i = i + 1
If Application.RecentFiles(i).Name = "ABC.xls" Then
Application.RecentFiles(i).Delete
End If
Next i

But don't forget, some items in the list will be just the file name, some
will include the path

--

HTH

RP
(remove nothere from the email address if mailing direct)


"phil6666" wrote in message
...

Using Excel 2002...

Is there any way to remove files from this list other than waiting for
them to be replaced over time?

Hi
you can set recently viewed files to zero
Tools options then general tab
Tina
"phil6666" wrote:


Using Excel 2002...

Is there any way to remove files from this list other than waiting for
them to be replaced over time?

Using Excel 2002...

Is there any way to remove files from this list other than waiting for
them to be replaced over time?


This one removes the first file (the second line puts the maximum back
to 9 files, which seemed to be required if I deleted all the files in
the list). Change the (1) if you want to delete other than the most
recent file.

Sub DelMRU()
Application.RecentFiles(1).Delete
Application.RecentFiles.Maximum = 9
End Sub


This one puts the current file back on the list.

Sub AddCurFileToMRU()
Application.RecentFiles.Add Name:=ActiveWorkbook.FullName
End Sub


I have a button for each on my toolbar.

This sounds like just what I need, but don't know how to add a button
to the toolbar other than those that are already available with
TOOLSCUSTOMIZE.

Could you point me in the right direction in MS Help?

thnx

On Fri, 18 Mar 2005 03:45:36 GMT, Andy wrote:

Using Excel 2002...

Is there any way to remove files from this list other than waiting for
them to be replaced over time?


This one removes the first file (the second line puts the maximum back
to 9 files, which seemed to be required if I deleted all the files in
the list). Change the (1) if you want to delete other than the most
recent file.

Sub DelMRU()
Application.RecentFiles(1).Delete
Application.RecentFiles.Maximum = 9
End Sub


This one puts the current file back on the list.

Sub AddCurFileToMRU()
Application.RecentFiles.Add Name:=ActiveWorkbook.FullName
End Sub


I have a button for each on my toolbar.

ToolsCustomizeCommandsMacros

Drag the Custom Button (yellow smiley face) to your toolbar, right
click on it, assign macro (you have to have a worksheet open so the
assign macro dialog box comes up). Right clicking on the button while
the ToolsCustomize dialog box is open will also give you some other
options (like changing the smiley face).

I followed Excel "help" and copy/pasted exactly what you wrote & it
works perfectly!!!

Now, if I only had a minimal clue what macros really can do.......


On Sat, 19 Mar 2005 04:58:47 GMT, Andy wrote:

ToolsCustomizeCommandsMacros

Drag the Custom Button (yellow smiley face) to your toolbar, right
click on it, assign macro (you have to have a worksheet open so the
assign macro dialog box comes up). Right clicking on the button while
the ToolsCustomize dialog box is open will also give you some other
options (like changing the smiley face).

Glad it worked.

Now, if I only had a minimal clue what macros really can do.......

Almost anything. I've barely scratched the surface!

OK....now Excel doesn't want me to use the macro because the digital
signature that I wrote isn't in the trusted root certification
authorities store.

How do I do that???

thnx


On Fri, 01 Apr 2005 21:25:19 -0500, phil6666
wrote:


I followed Excel "help" and copy/pasted exactly what you wrote & it
works perfectly!!!

Now, if I only had a minimal clue what macros really can do.......


On Sat, 19 Mar 2005 04:58:47 GMT, Andy wrote:

ToolsCustomizeCommandsMacros

Drag the Custom Button (yellow smiley face) to your toolbar, right
click on it, assign macro (you have to have a worksheet open so the
assign macro dialog box comes up). Right clicking on the button while
the ToolsCustomize dialog box is open will also give you some other
options (like changing the smiley face).