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
Please post replies to newsgroup to benefit others
Replace dead spam with ntl world to reply by email