Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freezepanes
Is it possible to freezepanes without having to first select the cell where
you want the freeze to take place? -- russ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freezepanes odd behavior | Excel Programming | |||
FreezePanes from VBA? | Excel Programming | |||
.FreezePanes | Excel Programming | |||
Help with Excel FreezePanes from code | Excel Programming | |||
freezepanes | Excel Programming |