Posted to microsoft.public.excel.programming

crmulle

external usenet poster

Posts: 11

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
.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hide the running macro	Vijay Chary	Excel Programming	0	December 4th 08 03:11 PM
Hide all windows while macro is running	Gary Keramidas	Excel Programming	6	February 12th 08 05:08 PM
Hide all windows while macro is running	John Bundy	Excel Programming	0	December 27th 06 03:13 PM
Hide the running macro	Norman Jones	Excel Programming	0	December 7th 06 04:32 PM
How to hide all the actions while a macro is running	milo[_2_]	Excel Programming	3	October 4th 03 03:29 AM

All times are GMT +1. The time now is 06:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us