ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide Macro Process (https://www.excelbanter.com/excel-programming/344297-hide-macro-process.html)

Brian Morrison[_2_]

Hide Macro Process
 
Is there a way to hide all the work the macro is doing so that the end user
doesnt see the code develope.

I have a macro that produces a bunch of charts and edits them. This
currently is all shown with the screen flashing back and forth.

Can i hide this?

TK

Hide Macro Process
 
Brian:

At the start of your code use:
Application.ScreenUpdating = False

at the end:
Application.ScreenUpdating = True

Good Luck
TK


"Brian Morrison" wrote:

Is there a way to hide all the work the macro is doing so that the end user
doesnt see the code develope.

I have a macro that produces a bunch of charts and edits them. This
currently is all shown with the screen flashing back and forth.

Can i hide this?



All times are GMT +1. The time now is 02:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com