View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
LSkarbek LSkarbek is offline
external usenet poster
 
Posts: 4
Default 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?