Application.screenupdating = false
your code that jumps around
Application.screenupdating = true


It may make the code easier to update if you drop all the .selects and
..activates. Just work directly with the range (for example).

worksheets("sheet99").select
range("a99").select
activecell.value = 33

could be replaced with:
worksheets("sheet99").range("a99").value = 33



John Calder wrote:

Hi

I run Excel 2000

I was wondering if there is some code that I can use to visually supress a
macro when it runs.

When I presently run a macro that initiates a number of various tasks the
sheet "jump's" about as the macros run. Its not a big deal but would be nice
if I could surpress this screen movement.

Is it possible?

Thanks

John

--

Dave Peterson