Not Unloading a UserForm

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Rather than using

UserForm1.Show
.....
Unload UserForm1

to speed things up I have removed the Unload since I will be calling the
UserForm at several places

However I've noticed when I close my excel sheet now, I tend to get
something like a VBE6.DLL error which leaves a file level lock on the
spreadsheet so I have to reboot to unlock it

Do I have to do something special to unload the UserForm on worksheet
close, and if so how do I do it please
 
/visible
Do I have to do something special to unload the UserForm on worksheet
close, and if so how do I do it please
Click to expand...
I've thought of a way round this now, but just wondered if I had to
unload it before I closed the workbook anyway

Seems strange coincidence this error's come in once I've switched the uf
to not unload

/invisible
 
Back
Top