I am using 'Application.ScreenUpdating = False' at the beginning of my
code, and '... = True' at the end. I am getting a grey Excel window on
my screen until the macro shuts down. Is there any way to minimize this
window while the macro is running?

Thanks for a response.


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=385041

Are you Unloading the UserForms that may be you triggered before? That
could be the reason. Could you tell whats in between the ScreenUpdating
lines?

Regards
Jose LUis



Chuckles123 Wrote:
I am using 'Application.ScreenUpdating = False' at the beginning of my
code, and '... = True' at the end. I am getting a grey Excel window on
my screen until the macro shuts down. Is there any way to minimize this
window while the macro is running?

Thanks for a response.


--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=385041

Thanks for your interest.

My code contains no UserForms.

My code opens and closes several Excel files plus one Word file. The
first Excel file that is opened remains open during macro processing; 3
of its WorkSheets are saved to a folder as individual files; depending
on value of a key cell, various Outlook e-mails are created and sent;
my macro shuts down the Excel application without saving the original
file opened.

HTH
Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=385041

Try including the keyword 'DoEvents' in your code at various places -
inside loops, and the start and end of any subroutines.

DoEvents releases the timeslice back to windows allowing it to process
other events that are waiting to be processed. Whilst this won't allow
you to minimise the window it may get rid of your grey box.


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=385041

I checked VB Help on 'DoEvents'; I also searched all the posts on this
site for the same thing.

I think 'DoEvents' may be overkill for my needs. I do not have any
UserForms in my code, I open and close maybe 10 Excel workbooks, I have
a few loops and a few subroutines but they are executed quickly.

I was confused by your line: "Whilst this won't allow you to minimise
the window it may get rid of your grey box." My grey box is the Excel
window; all that I want to do is make this grey box/Excel window not
appear on my screen. I don't mind, in fact I appreciate, application
file buttons appearing and disappearing in the XP Taskbar.

Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=385041

Hi Chuckles, sorry not been able to answer this before. Some times I'm
getting the the gray area that you describes too. I haven't been able
to catch the error. What i have noticed is that it appears after the
opening of several hmtl pages via the Explorer, unfortunately i can't
repeat the error at will, so i dont't understand why it surges. After
closing my files, quitting excel and sometimes restarting the PC it
disparears.

Hope this helps you in some way :(

Regards

Jose Luis


Chuckles123 Wrote:
I checked VB Help on 'DoEvents'; I also searched all the posts on this
site for the same thing.

I think 'DoEvents' may be overkill for my needs. I do not have any
UserForms in my code, I open and close maybe 10 Excel workbooks, I have
a few loops and a few subroutines but they are executed quickly.

I was confused by your line: "Whilst this won't allow you to minimise
the window it may get rid of your grey box." My grey box is the Excel
window; all that I want to do is make this grey box/Excel window not
appear on my screen. I don't mind, in fact I appreciate, application
file buttons appearing and disappearing in the XP Taskbar.

Chuckles123


--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=385041