Tom Ogilvy said:
Sorry, misread your post. (I actually couldn't find a stop button,
but Michael interpreted it as the Reset button). What are you
trying to achieve.
Hi Tom,
I have a spreadsheet with some event driven code (worksheet change
event specifically). This is also a shared workbook.
Occasionally, a user gets a 'Document Not Saved' message when they try
to save. I believe that this is being caused by an event driven code
somehow hanging or getting into some kind of loop, stopping the user
saving.
We are reviewing the code, but in the meantime, I wanted to give the
users a way to effectively click on 'reset' in the VBE (without having
to know anything about the VBE), to stop / reset any runnning code,
and effect a save.
I have used the line supplied by Michel
(amended to include a
'Do Events' after it as you suggested in reply to that posting, so I
will see if that gets the users saving again next time it occurs.
Thanks,
Alan.