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

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

--
Gary''s Student - gsnu200837


"lizalewis" wrote:

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

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

lizalewis wrote:

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

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
buttonExcel OptionsAdvancedDisplayRecently used filesset a value
between 0 and 50

--
Regards
Roger Govier

"lizalewis" wrote in message
...
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

THANK YOU!

"Roger Govier" wrote:

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
buttonExcel OptionsAdvancedDisplayRecently used filesset a value
between 0 and 50

--
Regards
Roger Govier

"lizalewis" wrote in message
...
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