Custom Views

[Guest]

I've been playing around with the Custom Views tool and it is giving me some
strange results. Example: I set up a view, in which the window is frozen at
cell J3 (i.e., everything above and to the left of J3 is static, and
everything to the right and below J3 will move as the window is scrolled to
the right/down.)

Then I save this as a custom view.

When I go back to view this custom view, the window freeze is changed to R3!

Has anyone ever seen this before? Is a macro a better solution here?

Dave

 

[Guest]

I think the answer to my question is to use VBA code to hide rows/columns and
assign that code to a button. Does anyone have any sample code that hides
rows and columns which I can use as a starting point?

Thanks,

Dave