Thread: VBA code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 108
Default 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.