Hidding the running of a Macro.

Zac · Apr 23rd, 2002, 11:39 AM

Is there a way to hide the running of a macro
(actually showing the macro in action) from the user?

IE: They push the Button, they wait, the results appear. Rather than they Push the Button, and the screen goes crazy showing what the macro is doing.

I saw this once before but I have no idea where to look in the Archive files.

Thanks,
Zac

Todd_M · Apr 23rd, 2002, 11:47 AM

Application.ScreenUpdating = False

your code goes here.....

Application.ScreenUpdating = True

Hope this helps-Todd

Zac · Apr 23rd, 2002, 11:52 AM

Thanks Todd.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 11:39 AM	#1
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	Is there a way to hide the running of a macro (actually showing the macro in action) from the user? IE: They push the Button, they wait, the results appear. Rather than they Push the Button, and the screen goes crazy showing what the macro is doing. I saw this once before but I have no idea where to look in the Archive files. Thanks, Zac

Apr 23rd, 2002, 11:47 AM	#2
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Application.ScreenUpdating = False your code goes here..... Application.ScreenUpdating = True Hope this helps-Todd

Apr 23rd, 2002, 11:52 AM	#3
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	Thanks Todd.