hide

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Hi

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

--
XL2002
Regards

William

(e-mail address removed)

| 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Macro to hide cols 2
vba code to enable macros 3
How to get Last Key or Key-Combo Pressed (Not Event)? 0
Progress indicator help wanted 2
Hide the close X in excel 2
Change macro button text when macro is invoked. 2
Macro to Hide/Unhide various columns 5

Back
Top