Hi

I've designed a VBA lookup form for a company using Excel 2000, VB6. I've
set it to autoload upon opening the Worksheet by using

ThisWorksheet
Private Sub Worksheet_Open()
frmMapping.Show
End Sub

Everything works fine on my Desktop version and also on the one posted on
the Company's intranet, except that (on the intranet version only), when you
switch to another application and then return the program hangs and you have
to end task via the Task Manager. Once this is closed, I've found the
original copy is still running in the background, so it appears to be trying
to load itself in twice after losing focus. It has been loaded onto the
intranet via Windows Explorer for Windows 2000.

Is there any way of resolving this, or must I force users to end the session
and create a new session every time with an Exit button and Application.Quit?

Any advice would be welcomed.