Run quietly
 

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

Run quietly
 

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

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

--

Vasant


"cogent" wrote in message
...
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

Run quietly
 

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" <vasantn *AT* aol *DOT* com wrote in message
...
Put the following code in the ThisWorkbook module of the workbook:

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

--

Vasant


"cogent" wrote in message
...
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

Run quietly
 

Shell "cmd.exe", vbMinimizedNoFocus

--

Vasant

"cogent" wrote in message
...
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" <vasantn *AT* aol *DOT* com wrote in message
...
Put the following code in the ThisWorkbook module of the workbook:

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

--

Vasant


"cogent" wrote in message
...
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

Run quietly
 

Alright!

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Shell "cmd.exe", vbMinimizedNoFocus

--

Vasant

"cogent" wrote in message
...
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" <vasantn *AT* aol *DOT* com wrote in message
...
Put the following code in the ThisWorkbook module of the workbook:

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

--

Vasant


"cogent" wrote in message
...
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