Visually Surpressing A Macro
 

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

Visually Surpressing A Macro
 

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

Visually Surpressing A Macro
 

Dave, thanks for your prompt response.

I should have mentioned that I am not a visual basic user. Could you be a
little more specific on what part of the code I should use and where exactly
should I copy it to?

Thanks


"Dave Peterson" wrote:

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

Visually Surpressing A Macro
 

Sub YourSubNameHere()
Application.screenupdating = false 'right at the top


your code that jumps around


Application.screenupdating = true 'right at the bottom
End Sub

John Calder wrote:

Dave, thanks for your prompt response.

I should have mentioned that I am not a visual basic user. Could you be a
little more specific on what part of the code I should use and where exactly
should I copy it to?

Thanks

"Dave Peterson" wrote:

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


--

Dave Peterson

Visually Surpressing A Macro
 

Dave

Thanks a lot...it works great !!

John




"Dave Peterson" wrote:

Sub YourSubNameHere()
Application.screenupdating = false 'right at the top


your code that jumps around


Application.screenupdating = true 'right at the bottom
End Sub

John Calder wrote:

Dave, thanks for your prompt response.

I should have mentioned that I am not a visual basic user. Could you be a
little more specific on what part of the code I should use and where exactly
should I copy it to?

Thanks

"Dave Peterson" wrote:

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


--

Dave Peterson