ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide the running macro (https://www.excelbanter.com/excel-programming/420835-re-hide-running-macro.html)

Vijay Chary

Hide the running macro
 
Hi Syn !! :)
It's done this way.


Sub abc()
Sheets("A").Select
Application.ScreenUpdating = False
'************YOUR CODE*************
End Sub

Regards, Vijay

"Syndrome" wrote:

I have four worksheets within a workbook named A,B,C,D. I have an auto_close
macro that runs three seperate macros that affects sheets B,C,D but I would
like the workbook to remain on sheet A whilst the macro is running.

Any help would be appreciated



All times are GMT +1. The time now is 08:56 AM.

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