Auto calc on, then turn off, then runtime error how to turn back on

Hi,

Intially autocalc is on.............i turn off automatic calc at some point in the macro..........macro gets a runtime error for some reason that i have not anticipated......user continues to try and run macro or maybe a diff macro.......run time error results because autocalc is off (set to manual) and a calc that was supposed to happen did not.

Any ideas how to handle this issue?

I know the best is not to have a runtime error with autocalc set to manual........but lets suppose this does happen. then what?

tom, thanks for the info.

But what i was trying to get at was lets suppose a user is running the macro who is not that excel literate and they get this run time error............i dont want to have to tell them to "do something" to get autocalc set back to automatic.......i was hoping there was some way i could handle it via code

great information!

Additional question:
Do you have to have such error handling in each procedure/function (ie make this statement...........On Error GoTo Error_Handler.........in each procedure or function.....or is there a best practice kinda location to put this) or is there some way regardless of where the run time error occurs to have it always goto "Error_Handler". Where does "Error_Handler" procedure need to be .......can it just be a regular procedure in the macro?

These may seem like dumb questions........i appologize.


Also, why did you have the program jump to clean exit .......why not just exit. Is there some reason you would not want to do a clean exit?

thanks for the info! very helpful information. error handling such as this i have not even considered........very helpful info.