Having an Excel Macro Process run without Seeing it run 1

[dyana]

Does anyone know what VBA code to insert to prevent the visual display of a macro being run?

dyana

 

[scottrod]

You can use Application.ScreenUpdating=False to keep the screen from flipping around, if you're selecting sheets, cells, etc. In some instances the process will be faster because the screen doesn't have to be updated. Application.ScreenUpdating=True turns it back on.

 

[acron]

Just to add a little to what scottrod has advised, I would suggest that it is not always necessary (in fact very rarely) to select cells from a running macro. Values, formatting etc can be assigned without actually selecting cells, or worksheets.

A.C.

 

[DaleWatson123321]

A.C.

I like your point.

What would be NICE addition, though, would be a couple of examples !!! ...then you get a STAR from me.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca