View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amir Amir is offline
external usenet poster
 
Posts: 14
Default Adding a cancel button

Hi,

I have a macro which takes a long time to run.

During the macro operation there is a form showing that the macro is
currently 'running'.

Which commands should I put in that form's Cancel button so that it with
cancel the macro operation?

I guess I should put some DoEvents lines in my macro code for that to work,
but I don't know the commands for the cancel button.

Guess the macro name is MyMacro.


Kind Regards,
Amir.