Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FreezePanes on a Row without using an ActiveWindow object
I believe that Freezing Panes is the only operation in VBA that requires you
to Select a cell, so no, you can't do it the way you want. You must use Select. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email on the web site) wrote in message oups.com... Is it possible to as make a FreezePanes assignment without using a Select and an ActiveWindow? Instead of: rows("2:2").Select ActiveWindow.FreezePanes = True something like Sheets("MySheet").Rows("2:2").FreezePanes = True |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FreezePanes on a Row without using an ActiveWindow object
Is it possible to as make a FreezePanes assignment without using a
Select and an ActiveWindow? Instead of: rows("2:2").Select ActiveWindow.FreezePanes = True something like Sheets("MySheet").Rows("2:2").FreezePanes = True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel.ActiveWindow Is Excel.ActiveWindow Returns False | Excel Programming | |||
FreezePanes from VBA? | Excel Programming | |||
.FreezePanes | Excel Programming | |||
freezepanes | Excel Programming | |||
Creating a Powerpoint object (in XP onwards) with an ActiveWindow | Excel Discussion (Misc queries) |