how to disable automatic full screen mode?

[Paul Kraemer]

Hi,

I received an Workbook from a customer of mine. It is in Excel 97-2003
format, but I am using Excel 2007. They want me to modify it to suit their
needs.

What is driving me crazy is that anytime I click on any cell on any
worksheet, the worksheet automatically goes to "Full Screen Mode" (where I do
not see the ribbon). To get the ribbon back, I have to click on the
upper-left hand corner of the window and click "Restore". I have to do this
over and over and over again as I need the ribbon to do the work I want to do.

I was wondering if this behavior is the result of some setting that I am not
aware of...if anyone has any idea, please let me know so I can disable this
setting.

Thanks in advance,
Paul

 

[Daryl S]

Paul -

I would look for code like this (it could be in Worksheet_SelectionChange or
some other event), so look in the current project:

Me.Application.WindowState = xlMaximized

You can comment it out, and then remember to uncomment it before you return
it to the user...