VBA code

[Paul]

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.

 

[Harald Staff]

Hi Paul

No.
Yes.
Post the code please, it's impossible to suggest anything without it.

HTH. Best wishes Harald

 

[Steve]

Why not insert at the appropriate point
if activesheet.name = "Sheet1" then
....
?


Steve