Hi All,
I have this workbook that has around 12-15 worksheets.
At present there is a formula gets() that takes a arugument called
"Calc".
now it is set to automatic recalculate in the prefereneces.
so whenever i change a sheet i have to then go to another sheet to
where the calc field resides and just change the number to any number
other then zero and immediately it calculates all the sheets in the
workbook.

So now,I want to recalculate only one sheet at a time instead of all
the sheets and also dont want to depend on the calc field of another
sheet.
So i made the preferences to manual and checked the box that says
'recalculte on save'.
and also in the function gets () im replacling the calc to '6'.
And for each sheet in vba- i wrote:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
ActiveSheet.Calculate
End Sub

But when i do alt+s to save it just saves but does not recalculate.

how do i make it recalculate when it saves..

Please help.
Thanks,
gilligans


--
gilligans
------------------------------------------------------------------------
gilligans's Profile: http://www.excelforum.com/member.php...o&userid=35026
View this thread: http://www.excelforum.com/showthread...hreadid=567193