VBA Macros that don't steal focus?
 

I have written a set of sub's and functions that handle formatting
several sheets in my workbook. The problem is that in the process of
activating the sheets and making my formatting changes the window
appears like it's going crazy. Is there a way I can turn off the focus
change before my macro runs amd then turn it back on after it's done?

Thanks,

Morph

VBA Macros that don't steal focus?
 

Morph.

- Use application.screenupdating
- Do not first issue select(ion) before taking action. This is a
beginners VBA mistake. Esp the XL macro recorded does this!

DM Unseen