hide

G

Guest

Is it possible to hide Excel while a vba macro is running
and then have it reopen when the macro is finished. If so,
what is the code I should use at the beginning and end of
the macro.
 
W

William

Hi

Sub MyMacro()
Application.Visible=False
'Code here
Application.Visible=True

--
XL2002
Regards

William

[email protected]

| Is it possible to hide Excel while a vba macro is running
| and then have it reopen when the macro is finished. If so,
| what is the code I should use at the beginning and end of
| the macro.
 
Top