Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
freezepanes
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
freezepanes
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|