ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   WHY IS FREEZE PAINS GREYED OUT (https://www.excelbanter.com/excel-discussion-misc-queries/260592-why-freeze-pains-greyed-out.html)

scamander

WHY IS FREEZE PAINS GREYED OUT
 
WHY IS FREEZE PAINS GREYED OUT in excel

Mike H

WHY IS FREEZE PAINS GREYED OUT
 
Maybe the worksheet is protected
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"scamander" wrote:

WHY IS FREEZE PAINS GREYED OUT in excel


מיכאל (מיקי) אבידן

WHY IS FREEZE PAINS GREYED OUT
 
I'm capable to Freeze a Worksheets pane even if i is protected.
[Common/standard protection - "Excel 2003"
Micky


"Mike H" wrote:

Maybe the worksheet is protected
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"scamander" wrote:

WHY IS FREEZE PAINS GREYED OUT in excel


Mike H

WHY IS FREEZE PAINS GREYED OUT
 
Micky,

In E2007 where I tested my solution you can't, so I've just discovered
another difference between 2003 & 2007. The only question that remains is why
have MS introduced this!!


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"מיכאל (מיקי) אבידן" wrote:

I'm capable to Freeze a Worksheets pane even if i is protected.
[Common/standard protection - "Excel 2003"
Micky


"Mike H" wrote:

Maybe the worksheet is protected
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"scamander" wrote:

WHY IS FREEZE PAINS GREYED OUT in excel


מיכאל (מיקי) אבידן

WHY IS FREEZE PAINS GREYED OUT
 
It's a pity that you didn't mention the "Excel" version.
However, this must be a "bug" in "Excel 2007".
In "Excel 2010" it has been taken care of and works filn like in "2003".

--
והמשך/י, *א, לקרוא את השורה הבאה:
***********
אם תגובתי עזרה לחץ/י, *א, על <כן בפס האופקי התחתון!
***********
מיכאל אבידן
מ*הל פורום "אופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"scamander" wrote:

WHY IS FREEZE PAINS GREYED OUT in excel


מיכאל (מיקי) אבידן

WHY IS FREEZE PAINS GREYED OUT
 
Mike,
I wrote to scamander - an OP should always(!) present his Excel version and
it would not hurt, anybody, if the OS version - will be present as well.
It took me a while to make this an "habit" in the "MS Office" forum I'm
moderating - and it has proved itself to be very helpful and most of all time
saving.
Micky


"Mike H" wrote:

Micky,

In E2007 where I tested my solution you can't, so I've just discovered
another difference between 2003 & 2007. The only question that remains is why
have MS introduced this!!


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"מיכאל (מיקי) אבידן" wrote:

I'm capable to Freeze a Worksheets pane even if i is protected.
[Common/standard protection - "Excel 2003"
Micky


"Mike H" wrote:

Maybe the worksheet is protected
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"scamander" wrote:

WHY IS FREEZE PAINS GREYED OUT in excel


Mike H

WHY IS FREEZE PAINS GREYED OUT
 
Mickey,

Agree, OP's should always post the version but there are so many 1 & 2 time
posters I think it will always be an issue.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"מיכאל (מיקי) אבידן" wrote:

Mike,
I wrote to scamander - an OP should always(!) present his Excel version and
it would not hurt, anybody, if the OS version - will be present as well.
It took me a while to make this an "habit" in the "MS Office" forum I'm
moderating - and it has proved itself to be very helpful and most of all time
saving.
Micky


"Mike H" wrote:

Micky,

In E2007 where I tested my solution you can't, so I've just discovered
another difference between 2003 & 2007. The only question that remains is why
have MS introduced this!!


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"מיכאל (מיקי) אבידן" wrote:

I'm capable to Freeze a Worksheets pane even if i is protected.
[Common/standard protection - "Excel 2003"
Micky


"Mike H" wrote:

Maybe the worksheet is protected
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"scamander" wrote:

WHY IS FREEZE PAINS GREYED OUT in excel


Gary Keramidas[_4_]

WHY IS FREEZE PAINS GREYED OUT
 
2007 was like vista, a necessary step to the next version, but actually
sucked. that's my opinion and i refused to use or sell either one to any of
my clients.

--


Gary Keramidas
Excel 2003


"מיכאל (מיקי) אבידן" <micky-a*at*tapuz.co.il wrote in message
...
It's a pity that you didn't mention the "Excel" version.
However, this must be a "bug" in "Excel 2007".
In "Excel 2010" it has been taken care of and works filn like in "2003".

--
והמשך/י, *א, לקרוא את השורה הבאה:
***********
אם תגובתי עזרה לחץ/י, *א, על <כן בפס האופקי התחתון!
***********
מיכאל אבידן
מ*הל פורום "אופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"scamander" wrote:

WHY IS FREEZE PAINS GREYED OUT in excel




All times are GMT +1. The time now is 11:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com