VBA code
I have a macro in sheet1 that automatically runs every 15
seconds and works on objects in that sheet.
Whenever I make another sheet active, the macro generates
an error because it expects the active sheet to be sheet1.
Is there a way to suspend the macro while another sheet is
active???
Is there a way to keep it operating even though another
sheet is active??
Thanks for any help.
|