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
-- 
Paul Kraemer

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...
-- 
Daryl S


"Paul Kraemer" wrote:

> 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
> -- 
> Paul Kraemer