ExcelBanter - Macros

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Macros (https://www.excelbanter.com/excel-programming/378213-macros.html)

Tonie

Macros

Who can I run a macro in the background and ensure that only the control
screen is visible. I don't want anybody to see what my macro is doing?

Dave Peterson

Macros

Maybe...

Application.screenupdating = false
'your code here
application.screenupdating = true

Tonie wrote:

Who can I run a macro in the background and ensure that only the control
screen is visible. I don't want anybody to see what my macro is doing?

--

Dave Peterson

All times are GMT +1. The time now is 04:56 PM.