I have written a VB macro that is very lengthy and executes a number of calculations.
If the macro is run and the Excel Option "Calculation Options" is set to "Automatic" - the macro takes ages. So it needs to be set to "Manual".
Is there any way of doing this directly in the VB script. This prevents idiots running it with it on.
I am using Excel 2007