Hiding Rows Causes Excel to Freeze

[muraii]

Hi,

I have never before run into a problem like this. I have an Excel file
which acts as a database of requests. I've been working on all its
logic, and now would like to give it some minimal usability tweaks.
For instance, I've hidden all rows with either no information or only
proprietary information in them. However, when I try to open this
file, it might take 20 minutes or so, even if hosted locally on my
machine. Unhiding the rows removes this problem.

I've tinkered with hiding different sets of rows, and during this
morning's goofing around I noticed that once I hide all rows from 1012
to 65536, even navigating the spreadsheet becomes cumbersome.

Is there some intrinsic piece of Excel's interface I'm missing? Do I,
by hiding a row, tell Excel to do some additional calculating on that
row, and, so by hiding 64K rows make Excel grind along?

Thanks,

Daniel

 

[Don Guillett]

Why not just set the scroll area instead? from help
ScrollArea Property
See Also Applies To Example Specifics
Returns or sets the range where scrolling is allowed, as an A1-style range
reference. Cells outside the scroll area cannot be selected. Read/write
String.

Remarks
Set this property to the empty string ("") to enable cell selection for the
entire sheet.

Example
This example sets the scroll area for worksheet one.

Worksheets(1).ScrollArea = "a1:f10"

 

[muraii]

That's a wonderful idea, Don. Thank you.

Daniel

 

[Don Guillett]

glad to help