[Office 2007] Auto-hide ribbon toggle button and control recent do

[Guest]

Hello,

I am wondering if any of you guys could help me out on a few questions that
I have. I am currently trying to create a button in our custom Excel
application to auto-hide the ribbon and unhide when needed. As well I would
like to know if it's possible to customize the recent documents list in Excel
2007 and how I would go about doing it. It would be great if anyone could
point me into the right direction.

Thanks in advance.

 

[Jim Rech]

I don't know what you mean by "auto-hide" but if you mean merely "hide" you
could use the built-in shortcut Ctrl-F1. If you need a button to do that
then it should run a macro that executes that key stroke:

SendKeys "^{F1}"

I don't recall whether there is a direct macro command for that. The Macro
Recorder records nothing.

The file MRU list is stored in the registry at:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\File MRU

VB code can be written to manipulate what is stored there.
--
Jim
| Hello,
|
| I am wondering if any of you guys could help me out on a few questions
that
| I have. I am currently trying to create a button in our custom Excel
| application to auto-hide the ribbon and unhide when needed. As well I
would
| like to know if it's possible to customize the recent documents list in
Excel
| 2007 and how I would go about doing it. It would be great if anyone could
| point me into the right direction.
|
| Thanks in advance.

 

[Guest]

Thanks Jim that is the answer that I am looking for!