Excel 2007 registry key for recent files

[scaffdog845]

Morning all,

Here's a stupid New Year's Oops!

I've had my Excel 2007 set up for the longest time to show the 30 most recent files when clicking on the office button. After changing it to 50 the office menu in Excel runs off the bottom of the screen and I can no longer get ot the options at the bottom to change it back.

Does anyone know the registry key to modify this setting back to the 30 that allowed the full menu to be visible?

[Andy Pope]

No need for registry tinkering.

Open excel
ALT+F11 to goto VBE
CTRL+G to goto Immediate Window

enter the following and press return.

Please Login or Register  to view this content.

[scaffdog845]

Please Login or Register  to view this content.

OUTSTANDING!!!! Worked like a charm. Much easier than a registry fix!