opening worksheet in background

Question

here's the process that i am running from a macro:

1. i open a worksheet
2. i add data to the worksheet
3. i save it
4. i close it

and i repeat the steps: 1, 2, 3... etc. (when i say I, i mean the stupid macro)

is it possible to open the worksheet in the background so that the user doesnt actually see that the worksheet is being opened?

Answer 1

Try using Application.ScreenUpdating. Set it to false before opening the worksheet, add the data and set it back to true afterwards.

Answer 2

You can also use application.visible = false to hide an instance of an Excel Application object to the user. ScreenUpdating will still show the workbook being opened in the taskbar.