Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Muting Macros
I have several macros which, upon execution, flash updates to the screen with
blinding speed, displaying the results of the commands. How can I inhibit this window chatter once the macros are de-bugged? -- Gary's Student |
#2
|
|||
|
|||
Hi Gary's,
How can I inhibit this window chatter once the macros are de-bugged? Application.ScreenUpdating=False 'Your code Application.ScreenUpdating=True Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
#3
|
|||
|
|||
First,
Application.ScreenUpdating = False '<Your code here Application.ScreenUpdating = True Second, if the reason your macros are flashing is that you're making selections/activations, eliminating them will eliminate the flashes, as well as speeding up your code. For instance, instead of Sheets("Sheet1").Activate Range("A1:J10").Select Selection.Copy Sheets("Sheet2").Activate Range("AB45").Select ActiveSheet.Paste use Sheets("Sheet1").Range("A1:J10").Copy Destination:= _ Sheets("Sheet2").Range("AB45") Working with range objects directly instead of the selection object makes your code smaller, faster, and IMO, easier to maintain. In article , "Gary's Student" wrote: I have several macros which, upon execution, flash updates to the screen with blinding speed, displaying the results of the commands. How can I inhibit this window chatter once the macros are de-bugged? |
#4
|
|||
|
|||
Thank you
-- Gary's Student "Jan Karel Pieterse" wrote: Hi Gary's, How can I inhibit this window chatter once the macros are de-bugged? Application.ScreenUpdating=False 'Your code Application.ScreenUpdating=True Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) |