Turn screen blank during Macro execution

[Eddie Kirby]

I am writing a macro program that moves from one spreadsheet
containing data to a second spreadsheet where the macro executes. The
macro executes in one spreadsheet then opens the second.

When the macro is executing, figures and lines are erased, deleted,
etc. Is there anyway I can get the second spreadsheet to be blank so
users can not see the macro executing?

It is necessary to be on the spreadsheet that is executing I just want
it to show a white screen or something.

Anyone?

 

[ward376]

application.screenupdating = false
'do your thing
application.screenupdating = true