Freezepanes
 

Is it possible to freezepanes without having to first select the cell where
you want the freeze to take place?
--
russ

Freezepanes
 

Yes, just replace my example row and column values with the one's you
need)...

With ActiveWindow
.SplitColumn = 4
.SplitRow = 7
.FreezePanes = True
End With

Note: Without the FreezePanes = True statement, the worksheet will be Split
instead of frozen.

--
Rick (MVP - Excel)


"Russ" wrote in message
...
Is it possible to freezepanes without having to first select the cell
where
you want the freeze to take place?
--
russ

Freezepanes
 

Freeze panes is one of the very few palces in the workd where, yes you do
need to select the cell. Also make sure you remove the freeze panes prior to
trying to apply it otherwise you can run into an error.

Another place you need to actually select the cell is on conditional
formatting...
--
HTH...

Jim Thomlinson


"Russ" wrote:

Is it possible to freezepanes without having to first select the cell where
you want the freeze to take place?
--
russ

Freezepanes
 

Thanks Rich. Your suggestion did the trick.
--
russ


"Rick Rothstein" wrote:

Yes, just replace my example row and column values with the one's you
need)...

With ActiveWindow
.SplitColumn = 4
.SplitRow = 7
.FreezePanes = True
End With

Note: Without the FreezePanes = True statement, the worksheet will be Split
instead of frozen.

--
Rick (MVP - Excel)


"Russ" wrote in message
...
Is it possible to freezepanes without having to first select the cell
where
you want the freeze to take place?
--
russ

Freezepanes
 

Hi Jim,
Rich Rothstein's suggestion seems to work. It does not require selecting
anything in the window.
--
russ


"Jim Thomlinson" wrote:

Freeze panes is one of the very few palces in the workd where, yes you do
need to select the cell. Also make sure you remove the freeze panes prior to
trying to apply it otherwise you can run into an error.

Another place you need to actually select the cell is on conditional
formatting...
--
HTH...

Jim Thomlinson


"Russ" wrote:

Is it possible to freezepanes without having to first select the cell where
you want the freeze to take place?
--
russ

Freezepanes
 

Always good to learn something new... I have seen dozens of replies to
questions on freeze panes and none of them used the split property...
--
HTH...

Jim Thomlinson


"Rick Rothstein" wrote:

Yes, just replace my example row and column values with the one's you
need)...

With ActiveWindow
.SplitColumn = 4
.SplitRow = 7
.FreezePanes = True
End With

Note: Without the FreezePanes = True statement, the worksheet will be Split
instead of frozen.

--
Rick (MVP - Excel)


"Russ" wrote in message
...
Is it possible to freezepanes without having to first select the cell
where
you want the freeze to take place?
--
russ

Freezepanes
 

The best I could tell, Split and Freeze are basically the same thing
underneath it all, the difference being whether you can adjust the location
of the split panes or not, and FreezePanes seems to be the toggle between
those two modes.

--
Rick (MVP - Excel)


"Jim Thomlinson" wrote in message
...
Always good to learn something new... I have seen dozens of replies to
questions on freeze panes and none of them used the split property...
--
HTH...

Jim Thomlinson


"Rick Rothstein" wrote:

Yes, just replace my example row and column values with the one's you
need)...

With ActiveWindow
.SplitColumn = 4
.SplitRow = 7
.FreezePanes = True
End With

Note: Without the FreezePanes = True statement, the worksheet will be
Split
instead of frozen.

--
Rick (MVP - Excel)


"Russ" wrote in message
...
Is it possible to freezepanes without having to first select the cell
where
you want the freeze to take place?
--
russ