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

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