Not Unloading a UserForm

[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

 

[Mike]

/visible

Do I have to do something special to unload the UserForm on worksheet
close, and if so how do I do it please

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