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

On Thu, 29 Jan 2004 at 22:07:09, Mike (Mike )
wrote:

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