Open Recent

[lizalewis]

I have gotten used to this software and have set my commonly used commands in
the ribbon - but I miss the display of recently used files - am I missing
something or did Microsoft omit this great option in the 2007 release

 

[Gary''s Student]

Try this small UDF:

Function CapCounter(r As Range) As Integer
s = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
v = r.Value
l = Len(v)
CapCounter = 0
For i = 1 To l
ch = Mid(v, i, 1)
If InStr(s, ch) > 0 Then
CapCounter = CapCounter + 1
End If
Next
End Function

 

[Bob I]

They are in the "Office button" The round icon in the upper left.

 

[Roger Govier]

Hi

When you click the round Office button, you see in the right hand side of
the pane a list of your recently used files.
If you want to alter the number of files displayed, then round Office
button>Excel Options>Advanced>Display>Recently used files>set a value
between 0 and 50

 

[lizalewis]

THANK YOU!

Hi

When you click the round Office button, you see in the right hand side of
the pane a list of your recently used files.
If you want to alter the number of files displayed, then round Office
button>Excel Options>Advanced>Display>Recently used files>set a value
between 0 and 50