ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   User form help (https://www.excelbanter.com/excel-programming/361326-user-form-help.html)

matpj[_69_]

User form help
 

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


Ardus Petus

User form help
 
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




matpj[_70_]

User form help
 

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


Ardus Petus

User form help
 
No, this is perfectly OK.

--
AP

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

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





All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com