ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Clicking on restore window button changing the freeze pane in exce (https://www.excelbanter.com/excel-discussion-misc-queries/32593-clicking-restore-window-button-changing-freeze-pane-exce.html)

SRIRAM

Clicking on restore window button changing the freeze pane in exce
 
Hi,

In our application after clicking a button in excel , we are
programmatically setting the freeze pane for excel workbbook.This click event
takes some time even it calls webservice.But in mean time if the user clicks
on "Restore" window in inner part of excel, this freeze pane setting is
changed from the requires setting that has been done during programming.

rn=toSheet.get_Range(sqlReportProperties.FreezePan e,missing);
((Excel.Range)rn.Cells[1,1]).Activate();
excelApplication.Windows[1].FreezePanes=true;


Can any one please urgently help on this.

thanx
sriram


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com