Run quietly

[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

 

[Vasant Nanavati]

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

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

 

[cogent]

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

W

 

[Vasant Nanavati]

Shell "cmd.exe", vbMinimizedNoFocus

--

Vasant

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

W

 

[cogent]

Alright!

Shell "cmd.exe", vbMinimizedNoFocus