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.

VBA code
 

Hi Paul

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

HTH. Best wishes Harald

"Paul" skrev i melding
...
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.

VBA code
 

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


Steve


"Harald Staff" wrote in message
...
Hi Paul

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

HTH. Best wishes Harald

"Paul" skrev i melding
...
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.