$$Excel-Macros$$ Re: xls calculation option becomes manual every time

2009-07-25 Thread Dilip Pandey
Hi Debashis, I think this problem is somewhat related to the differences between featurs of Excel 2003 & Excel 2007. If you are considering the file, which I have attached then I do not see any "grouping" problem in that. Dear "Group", Can anyone research on this, who has the Excel 2007 install

$$Excel-Macros$$ Re: xls calculation option becomes manual every time

2009-07-25 Thread DEBASHIS BANERJEE
Dear Friend , whats happening while I open this file , the work sheet is not opened forwithly. i am to go to exl option , there it is required to activate calculation option as automatic.. then it runs.. another file is there whose file name has been changed as file name .[gro

$$Excel-Macros$$ Re: xls calculation option becomes manual every time

2009-07-25 Thread Dilip Pandey
Hi Debashish, Not sure about Excel 2007, but below is what I have tried on Excel 2003 and it is working great. 'Enter following in workbook code area:- Private Sub workbook_open() Call CalcStatus End Sub 'Enter following in any module (say module 1) code area:- Sub CalcStatus() Cells(1, 1).Select