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