Run quietly

C

cogent

Hello again

I have a spreadsheet that runs automatically using Windows scheduler.

How can I make sure that it runs "minimized" or "quiet" so that it does not
disturb me when I happen to be working (on the same machine)?

Thank you.

W
 
V

Vasant Nanavati

Put the following code in the ThisWorkbook module of the workbook:

Private Sub Workbook_Open()
Application.WindowState = xlMinimized
End Sub
 
C

cogent

Thank you very much. out of curiosity is there any way to accomplish the
same objective with the Shell window (ie DOS?).

W
 
V

Vasant Nanavati

Shell "cmd.exe", vbMinimizedNoFocus

--

Vasant

cogent said:
Thank you very much. out of curiosity is there any way to accomplish the
same objective with the Shell window (ie DOS?).

W
Click to expand...
 
Top