Mystery objects
 

Hi all,

I have recently spent a lot of time developing an Excel-based project
but am stuck on one problem that I just can't find an answer to.

My project is password protected. If I open it, cause a form to be
displayed (any form) and then close or quit Excel, the project
password prompt appears.

I know this symptom is commonly due to objects not being released. I
have therefore put together a very simple test workbook comprising one
sheet and one form. The sheet has a button to display the form. The
form has a single button which performs an Unload Me.

The worksheet code is simply:

Private Sub showform_Click()

Dim fm As New UserForm1

fm.Show
' (form then unloads itself)
Set fm = Nothing

End Sub

UserForms.Count is zero after I run this. There is nothing else in
the workbook. The problem doesn't occur if I open and then quit
without showing the form.

I have also tried similar code without declaring a new object (i.e.
UserForm1.Show etc) but with the same result.

I am using VB 6.3 in Excel 2002.

Any advice would be very greatly appreciated.

Thanks
Simon (London).