issues with shared workbook how to pause macro and restart macro

hi all
i have some code that when workbook starts a macro called "auto save" every 30 sec's it saves and updates screen issue i have got is that if a userform is open at the time the macro runs to save it crashes and closes workbook only in "shared" i so i had the idea of stopping the macro if a userform is visable issue i have got is how to restart the marco once the userform is hidden here my code :

Please Login or Register  to view this content.

module code:

Please Login or Register  to view this content.

i also tryed worksheet change event but if a cell is fill by userform it does not see the event but does if cell is manually filled


thanks in advance guys


cheers

shane

Hi guys has any one got a idea on this

Cheers
Shane

Why not just use Excel's built-in autosave?

Please Login or Register  to view this content.