Don't show the steps in a macro
 

I don't want the users to see all of the steps in my macro. Is there a way
to just have a status bar and a message when complete instead?

Don't show the steps in a macro
 

put

sub your_name
application.screenupdating = false
'your code
..
..
application.screenupdating = true
msgbox "Report Complete"
end sub

--


Gary


"LSkarbek" wrote in message
...
I don't want the users to see all of the steps in my macro. Is there a way
to just have a status bar and a message when complete instead?

Don't show the steps in a macro
 

Thanks! I'll give it a try.

"Gary Keramidas" wrote:

put

sub your_name
application.screenupdating = false
'your code
..
..
application.screenupdating = true
msgbox "Report Complete"
end sub

--


Gary


"LSkarbek" wrote in message
...
I don't want the users to see all of the steps in my macro. Is there a way
to just have a status bar and a message when complete instead?