Question Regarding Status Frames and/or Message Boxes

[TheClayTaurus]

I'm working on a template for a large database that will be used to input and review data by many less savvy users. I've written a macro that reformats the sheet everytime it is saved so that the style is maintained. The problem is, it jumps all around when it's running, and if the user didn't expect this they might think that excel went crazy. (Like I said, less savvy users...) The solution I'd like to implement to avoid this problem is a simple message box or status frame that pops up at the beginning of the macro (to keep the user at bay) and then automagically closes at the program's end. The only method I've uncovered is the standard message box that prompts you to click OK to continue running. Can anyone help me out?

Thanks!

 

[LTunnicliffe]

You can also put the line Application.ScreenUpdating = False and the screen won't jump around (Jump, Jump, ... Jump Around). Sorry broke into rap there for a second. Then at the end set it back to true.

Hope this helps!

LT

 

[nevillestoke]

Would turning the screen updating off solve your problem?

Application.ScreenUpdating = False

 

[TheClayTaurus]

That was perfect. Wish I thought of it. THANKS!

 

[Juan Pablo González]

Just remember to set it to True at the end of the macro, to prevent unexpected behaviors, especially in XP.

 

[nevillestoke]

Good Point Juan - thanks for making it!