Att. [EMAIL PROTECTED]
Place below code in your sheets personal module:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Msg As String
If Application.Calculation = xlCalculationManual Then
Msg = MsgBox("Sheet has changed. Do you want to recalculate?", vbYesNo +
vbDefaultButton1)
If Msg = vbYes Then
Application.Calculate
End If
End If
End Sub
Alokeshwar
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
--- On Wed, 3/9/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ Controlling Excel Automatic Calculation???
To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com>
Date: Wednesday, 3 September, 2008, 4:09 PM
Hi
I’m trying to make a simple routine in excel VB so, when a command
button is pressed, the whole workbook is calculated (I have automatic
calculation set to manual). I also want to display a warning message
to the end user when input data is changed but the “calculate” button
has not been pressed.
Can anyone point me in the right direction?
Any help would be very much appreciated.
Download prohibited? No problem. CHAT from any browser, without download.
Go to http://in.webmessenger.yahoo.com/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
