Hiding the macro
 

Hey folks,
What's the best way to hide your macro when it is launched... I have a 3
minute macro and would like to hide all the flashing screens from the user...
What is the best way to do this?

Thanks
DJ

Hiding the macro
 

Application.ScreenUpdating = Fals

--
Mountain_Dewsk
-----------------------------------------------------------------------
Mountain_Dewski's Profile: http://www.excelforum.com/member.php...fo&userid=1920
View this thread: http://www.excelforum.com/showthread.php?threadid=37389

Hiding the macro
 

"Duncan_J" wrote in message
...
Hey folks,
What's the best way to hide your macro when it is launched... I have a 3
minute macro and would like to hide all the flashing screens from the
user...
What is the best way to do this?

Application.screenupdating = false

(then true at the end)

Hiding the macro
 

Thanks! Worked great!

"Duncan_J" wrote:

Hey folks,
What's the best way to hide your macro when it is launched... I have a 3
minute macro and would like to hide all the flashing screens from the user...
What is the best way to do this?

Thanks
DJ