resetting manual calculation across all the workbook - Page 2

keithkemble · Feb 14th, 2004, 07:07 PM

If a user sets the calculation to be manual via tools etc is there a way to use "thisworkbook privat sub workbook_change" etc to automatically reset the calculation back to automatic.

I have tried worksheet events but I need a global statement that ensures automatic calculation other than when VB routines are running.

For your ino Vb routines switch back to auto but I need some insurance policy to guarantee auto setting.

Feb 14th, 2004, 07:07 PM	#1
keithkemble Join Date: Feb 2002 Location: Leicestershire, U K Posts: 139	resetting manual calculation across all the workbook If a user sets the calculation to be manual via tools etc is there a way to use "thisworkbook privat sub workbook_change" etc to automatically reset the calculation back to automatic. I have tried worksheet events but I need a global statement that ensures automatic calculation other than when VB routines are running. For your ino Vb routines switch back to auto but I need some insurance policy to guarantee auto setting. __________________ Participation makes team work

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode