Hi,
I have a user form that is shown using the Workbook Open property.

If I switch to a different application on my desktop and then go bac
to Excel, I get the user form popping up without the excel backgroun.
the only way I can get excel back is by closing the userform.

does anyone know why this happens or how I can stop it?

many thanks,
Mat

--
matp
-----------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=54156

Are you sure there is no Apllication.Visible=False somewhere in your code?

What you describe does not happen by me.

HTH
--
AP

"matpj" a écrit dans le
message de news: ...

Hi,
I have a user form that is shown using the Workbook Open property.

If I switch to a different application on my desktop and then go back
to Excel, I get the user form popping up without the excel backgroun.
the only way I can get excel back is by closing the userform.

does anyone know why this happens or how I can stop it?

many thanks,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=541562

no, there's the following in my code though:

Application.DisplayAlerts = False

Application.ScreenUpdating = False


would these cause anything similar?


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=541562