Prev: Removing Duplicates from multiple worksheets
Next: How to add to a macro
From: Paul Kraemer on 5 Feb 2010 11:47
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
From: Daryl S on 5 Feb 2010 12:49
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
 | 
Pages: 1
Prev: Removing Duplicates from multiple worksheets
Next: How to add to a macro