"Rob" wrote in message
...
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