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.