Hide Screens While Macro is Running
 

I don't want the user to see the various spreadsheets and items that pop up
during a macro. How can I make this disappear while the macro is running?

Thank you,
crmulle

Hide Screens While Macro is Running
 

application.screenupdating = false
'lots of code here
application.screenupdating = true


crmulle wrote:

I don't want the user to see the various spreadsheets and items that pop up
during a macro. How can I make this disappear while the macro is running?

Thank you,
crmulle

--

Dave Peterson

Hide Screens While Macro is Running
 

Put this line at the beginning of the macro:
Application.ScreenUpdating = False

And this one at the end:
Application.ScreenUpdating = True


"crmulle" wrote:

I don't want the user to see the various spreadsheets and items that pop up
during a macro. How can I make this disappear while the macro is running?

Thank you,
crmulle

Hide Screens While Macro is Running
 

Thank you!

"Tim" wrote:

Put this line at the beginning of the macro:
Application.ScreenUpdating = False

And this one at the end:
Application.ScreenUpdating = True


"crmulle" wrote:

I don't want the user to see the various spreadsheets and items that pop up
during a macro. How can I make this disappear while the macro is running?

Thank you,
crmulle

Hide Screens While Macro is Running
 

THANK YOU!

"Dave Peterson" wrote:

application.screenupdating = false
'lots of code here
application.screenupdating = true


crmulle wrote:

I don't want the user to see the various spreadsheets and items that pop up
during a macro. How can I make this disappear while the macro is running?

Thank you,
crmulle

--

Dave Peterson
.