Thread: Freeze Panes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Wei-Dong Xu [MSFT] Wei-Dong Xu [MSFT] is offline
external usenet poster
 
Posts: 120
Default Freeze Panes

Hi Rohit,

For this scenario, I'd suggest you can add this two lines of code into the
SetFrees method of my sample.
oss.WorkSheets("Sheet1").Activate();
oss.ActiveSheet.Range("B3").Cells.Select();

This method should be:
function SetFrees()
{
oss.WorkSheets("Sheet1").Activate();
oss.ActiveSheet.Range("B3").Cells.Select();
oss.ActiveWindow.FreezePanes = true;
}

Before we set the freezePanes at the worksheet, we can select the cell and
the FreePanels will be set to Row 2 and Col2.

If your issue remains, could you be so kind to build one repro page for me
so that I can research this issue then? Thanks in advance!

You can email me the file or attached it in this thread (please zip the
file). My email account is: (please remove the
online from the email, which avoids spam)

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong XU (WD)
Microsoft Product Support Services
Get Secure! -
www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.