Excel Macro Help

[Microedge]

I recorded a macro to jump from sheet to sheet. The macro runs ok but you can see the screen flashing when the macro runs as it jumps from sheet to sheet. Does anyone know how I can run the macro in the background?

 

[Lockjaw]

Application.screenupdating = false

This will turn off the visual you are seeing when the macro jumps from sheet to sheet.

 

[Microedge]

Ok Thanks

i have tried it and it works