Can I freeze pane on an inactive worksheet?
 

In VBA it is possible to set a point to "freeze panes". Can this be
applied to a non-active worksheet?

Thanks


--
Mcubitt
------------------------------------------------------------------------
Mcubitt's Profile: http://www.excelforum.com/member.php...o&userid=16736
View this thread: http://www.excelforum.com/showthread...hreadid=319377

Can I freeze pane on an inactive worksheet?
 

Freeze Panes is the only operation that requires that you select
a cell, thus you can't freeze panes on an inactive worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Mcubitt" wrote in message
...

In VBA it is possible to set a point to "freeze panes". Can
this be
applied to a non-active worksheet?

Thanks


--
Mcubitt
------------------------------------------------------------------------
Mcubitt's Profile:
http://www.excelforum.com/member.php...o&userid=16736
View this thread:
http://www.excelforum.com/showthread...hreadid=319377