DisplayGridlines should be a property of Worksheet class, not Wind
 

In my opinion, the gridline visibility should be a property of the worksheet
(or macrosheet), not the one of the window containing the worksheet. I mostly
dislike gridlines, and when I open a New Window (from the Window menu in XL),
I get another window on the same worksheet, but this one has always gridlines
on.

Or maybe there is a good reason the way it is now - in this case let me know
please.

Thank you.

Stefano Gatto

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I don't speak for MS. But I bet they did it this way to make it flexible for
everyone.

If I wanted grid lines on one window and no grid lines on a different window (of
the same worksheet), how would I do it?

You could always turn them off to get what you want.

(I don't like the gridlines either!)

This may make them less painful (not completely painless, though):
http://groups.google.com/groups?selm...6324%40msn.com

Stefano Gatto wrote:

In my opinion, the gridline visibility should be a property of the worksheet
(or macrosheet), not the one of the window containing the worksheet. I mostly
dislike gridlines, and when I open a New Window (from the Window menu in XL),
I get another window on the same worksheet, but this one has always gridlines
on.

Or maybe there is a good reason the way it is now - in this case let me know
please.

Thank you.

Stefano Gatto

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson

Hi Dave,

Adding H4000 to
HKEY_CURRENT_USER\Software\MicÂ*rosoft\Office\10.0 \Excel\OptioÂ*ns\Option3
works well in this case and for me, except that new windows on worksheets
WITH gridlines won't have gridlines either.

Maybe the best MS could do is to create a new DisplayGridlines property for
the worksheet/macrosheet classes and have Windows "inherit" that setting when
created (by the way, the first Window showing a worksheet DOES inherit this
setting, but not the following ones, how would you explain this
inconsistency? i.e. why the ones following the first one would need the to
inherit from the registry?).

Thank you for your constructive answer and have a nice day.
--
Stefano Gatto
Geneva, Switzerland

"Dave Peterson" wrote:

I don't speak for MS. But I bet they did it this way to make it flexible for
everyone.

If I wanted grid lines on one window and no grid lines on a different window (of
the same worksheet), how would I do it?

You could always turn them off to get what you want.

(I don't like the gridlines either!)

This may make them less painful (not completely painless, though):
http://groups.google.com/groups?selm...6324%40msn.com

Stefano Gatto wrote:

In my opinion, the gridline visibility should be a property of the worksheet
(or macrosheet), not the one of the window containing the worksheet. I mostly
dislike gridlines, and when I open a New Window (from the Window menu in XL),
I get another window on the same worksheet, but this one has always gridlines
on.

Or maybe there is a good reason the way it is now - in this case let me know
please.

Thank you.

Stefano Gatto

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson

On the Forms toolbar there is a button (It's 5 rows of 5 dots) for
toggling the grid lines on and off, put that on your toolbar


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390541

I don't have an explanation why the gridlines default to being there for a new
window.

(I find it irritating, but I just click that button to toggle the gridlines and
I'm on to the next irritant!)

Stefano Gatto wrote:

Hi Dave,

Adding H4000 to
HKEY_CURRENT_USER\Software\MicÂ*rosoft\Office\10.0 \Excel\OptioÂ*ns\Option3
works well in this case and for me, except that new windows on worksheets
WITH gridlines won't have gridlines either.

Maybe the best MS could do is to create a new DisplayGridlines property for
the worksheet/macrosheet classes and have Windows "inherit" that setting when
created (by the way, the first Window showing a worksheet DOES inherit this
setting, but not the following ones, how would you explain this
inconsistency? i.e. why the ones following the first one would need the to
inherit from the registry?).

Thank you for your constructive answer and have a nice day.
--
Stefano Gatto
Geneva, Switzerland

"Dave Peterson" wrote:

I don't speak for MS. But I bet they did it this way to make it flexible for
everyone.

If I wanted grid lines on one window and no grid lines on a different window (of
the same worksheet), how would I do it?

You could always turn them off to get what you want.

(I don't like the gridlines either!)

This may make them less painful (not completely painless, though):
http://groups.google.com/groups?selm...6324%40msn.com

Stefano Gatto wrote:

In my opinion, the gridline visibility should be a property of the worksheet
(or macrosheet), not the one of the window containing the worksheet. I mostly
dislike gridlines, and when I open a New Window (from the Window menu in XL),
I get another window on the same worksheet, but this one has always gridlines
on.

Or maybe there is a good reason the way it is now - in this case let me know
please.

Thank you.

Stefano Gatto

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson


--

Dave Peterson

Thanks Dave and Paul for the suggestion, but I knew and use it since years.
When I (re)install Excel, the first thing I do is add that tool to the
Worksheet tollbar! All colleagues around me also have it there :-)

I think the suggestion to Microsoft would be to have this property moved
from the window class to the worksheet class, and have it stored
persistently, so to remain constant from one session to the other. I
personally do not see any good reason to have that property at the level of
the window class, but would keep it for backwards compatibility.
--
Stefano Gatto


"Dave Peterson" wrote:

I don't have an explanation why the gridlines default to being there for a new
window.

(I find it irritating, but I just click that button to toggle the gridlines and
I'm on to the next irritant!)

Stefano Gatto wrote:

Hi Dave,

Adding H4000 to
HKEY_CURRENT_USER\Software\MicÂÂ*rosoft\Office\10 .0\Excel\OptioÂÂ*ns\Option3
works well in this case and for me, except that new windows on worksheets
WITH gridlines won't have gridlines either.

Maybe the best MS could do is to create a new DisplayGridlines property for
the worksheet/macrosheet classes and have Windows "inherit" that setting when
created (by the way, the first Window showing a worksheet DOES inherit this
setting, but not the following ones, how would you explain this
inconsistency? i.e. why the ones following the first one would need the to
inherit from the registry?).

Thank you for your constructive answer and have a nice day.
--
Stefano Gatto
Geneva, Switzerland

"Dave Peterson" wrote:

I don't speak for MS. But I bet they did it this way to make it flexible for
everyone.

If I wanted grid lines on one window and no grid lines on a different window (of
the same worksheet), how would I do it?

You could always turn them off to get what you want.

(I don't like the gridlines either!)

This may make them less painful (not completely painless, though):
http://groups.google.com/groups?selm...6324%40msn.com

Stefano Gatto wrote:

In my opinion, the gridline visibility should be a property of the worksheet
(or macrosheet), not the one of the window containing the worksheet. I mostly
dislike gridlines, and when I open a New Window (from the Window menu in XL),
I get another window on the same worksheet, but this one has always gridlines
on.

Or maybe there is a good reason the way it is now - in this case let me know
please.

Thank you.

Stefano Gatto

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson


--

Dave Peterson