I think the excel application is in the background. the Userform should
be brought to the front of the excel application but not to the front of
other applications. So before doing the show I would bring the excel
window to the foreground.

ActiveWindow.Activate
or
Application.ActiveWindow.Activate

Do yu have multiple workbooks opened in the same window and one of the
other workbooks is the active workbook?


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165080

Microsoft Office Help