Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One of lifes little mystery? | New Users to Excel | |||
MYSTERY!! | Excel Discussion (Misc queries) | |||
Mystery Cell | Excel Discussion (Misc queries) | |||
Mystery Formats | Excel Programming | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming |