Open Recent

L

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
 
G

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
 
R

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
 
L

lizalewis

THANK YOU!

Roger Govier said:
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
Click to expand...
 
Top