Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
On Calculate question
In the "This Workbook" object I have a subroutine as follows:
Private Sub Workbook_SheetCalculate(ByVal Sh As Object) Call Impact2 End Sub The subroutine Impact2 can be found below: Public Sub Impact2() If MsgBox("Would you like to record the changes that were just made?", vbYesNo, "Record Changes?") = vbNo Then Exit Sub End If End Sub My problem is that when I calculate, Impact2 is run 10 times and I have to select 'No' every time before the code finishes running. Is the workbook calculating more than once? (I have number of iterations set to 0). What can I do to fix this? Thanks for your help, Chad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate time does not calculate | Excel Discussion (Misc queries) | |||
Code Question - Calculate eBay Fees Automatically | Excel Worksheet Functions | |||
basic question - how to calculate a cumulative percentage? | Excel Worksheet Functions | |||
Basic question - how to calculate a cumulative percentage | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) |