Here's an interesting "feature": Some window properties are more
"sticky" than others, at least in Excel 2000 (9.0).
To see what I mean, open a new workbook and make sure it has at least
two worksheets, "Sheet1" and "Sheet2." On Sheet1, pull up
Tools/Options and in the "Window options" part of the form, turn off
gridlines for that sheet (deselect the checkbox). OK out of the dialog
box and observe Sheet1's gridlines to be hidden. Go to Sheet2 - its
gridlines are still there. Back to Sheet1, gridlines still gone.
While on Sheet1, open up Tools/Options again, reselect gridlines, and
this time turn off the "Vertical scroll bar." OK out of the dialog box
and verify that Sheet1's vertical scroll bar is indeed missing. Now go
to Sheet2 - its vertical scroll bar is gone too!
This latter "sticky" behavior appears to exist only for the following
properties of the ActiveWindow:
.DisplayHorizontalScrollBar
.DisplayVerticalScrollBar
.DisplayWorkbookTabs
I could not find this documented in the Excel help files. This makes
trying to capture a workbook's "state" difficult because you cannot
cycle through, activating each sheet in turn, and storing its
properties so you can restore those properties later. As soon as you
get to a sheet whose DisplayVerticalScrollBar property is set to
false, every sheet after that will have that property set to false
too.
Bookmarks