freezepanes

[Guest]

Is it posible to freeze panes on another sheet / workbook without actually
going to the sheet?

'here's what I'm doing now:
application.goto sheet2.cells(3,2)
activewindow.freezepanes=true
application.goto sheet1.cells(1,1) 'where I was before

 

[Rob Bovey]

Is it posible to freeze panes on another sheet / workbook without actually
going to the sheet?

Hi Rob,

Unfortunately, no. This is one of the very few situations in Excel
programming where you just have to activate/select something in order to do
what you need to do.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm