Iteration question

[martins]

I have a work book where Iteration option is selected. The problem is if the workbook gets saved under a different name the Iteration option appears to get unticked. Should this happen and if so, is there any way of making sure it remains permanent?

[NBVC]

I find those options always to be very volatile...

It kind of depends on what the users settings are at the time of creating, opening the file...

The automatic calculation option is another one that for some unknown reason gets turned off spontaneously.

One way to ensure it is on when the workbook is opened, is to incorporate an event macro.

Hit Alt+F11 to go the VBE editor and go to View|Project Explorer to make sure the Project Explorer pane is visible. Expand the VBA project for the workbook you are working on and double-click This Workbook.

Paste this code and save the workbook.

Please Login or Register  to view this content.

Note: You can change the .MaxChange value if desired.

Now when you open the workbook, the Iteration should be set on.