| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not Unloading a UserForm
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform Help | Excel Programming | |||
| Unloading User Forms? | Excel Programming | |||
| Unloading A Form | Excel Programming | |||
| Unloading an Add-In | Excel Programming | |||
| How to force Workbook's macro unloading? | Excel Programming | |||
![Mike[_49_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
