Posted to microsoft.public.excel.programming

[email protected][_2_] gimme_this_gimme_that@yahoo.com[_2_] is offline

external usenet poster

Posts: 236

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel.ActiveWindow Is Excel.ActiveWindow Returns False	Neal Andrews	Excel Programming	1	October 26th 06 11:10 AM
FreezePanes from VBA?	G Lykos	Excel Programming	8	September 23rd 06 04:06 PM
.FreezePanes	Bob McClellan	Excel Programming	9	September 14th 06 02:20 PM
freezepanes	Rob	Excel Programming	1	January 6th 06 04:17 PM
Creating a Powerpoint object (in XP onwards) with an ActiveWindow	BizMark	Excel Discussion (Misc queries)	0	August 12th 05 12:46 PM

All times are GMT +1. The time now is 04:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us