When a user clicks on open in excel, the default is to open a window
that displays all of your excel files. There is an option that causes
excel to go into a full screen mode when you click on open. This allow
you to see all of the excel files that can fit on a full screen instead
of having to scroll through the normal open pop up window.

I would appreciate it if someone could tell me where to find the open
option that causes the files to be displayed in a full screen mode.

Thanks,
Wallis

turn on the macro recorder while you do it manually. Hopefully that will
show you the code you need.

--
Regards,
Tom Ogilvy

"Wallis" wrote in message
oups.com...
When a user clicks on open in excel, the default is to open a window
that displays all of your excel files. There is an option that causes
excel to go into a full screen mode when you click on open. This allow
you to see all of the excel files that can fit on a full screen instead
of having to scroll through the normal open pop up window.

I would appreciate it if someone could tell me where to find the open
option that causes the files to be displayed in a full screen mode.

Thanks,
Wallis