ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I remove a UserForm from a workbook? (https://www.excelbanter.com/excel-programming/392258-how-do-i-remove-userform-workbook.html)

Bill V

How do I remove a UserForm from a workbook?
 
I have a large project (10MB) with many userforms generated over about 10
years. I am now using Excel 2003. Many of these userforms are outdated and
now amount to clutter and add code bloat. I always thought that I could just
export them but they seem to stay in the project.

George

How do I remove a UserForm from a workbook?
 
Hi, Bill:

You might need to delete some of your macros and also delete the
userforms you do not need.

Thanks,

George


FSt1

How do I remove a UserForm from a workbook?
 
hi,
you can delete. this is done in the vb editor. Alt+F11
the the project window (far left), expand your project(file).
right click the undesireable form, click remove form
vb will ask if you want to export. click no.
form delete.
might be a good idea to export first and archive for possible future
reference.
a suggestion.
Regards
FSt1

"Bill V" wrote:

I have a large project (10MB) with many userforms generated over about 10
years. I am now using Excel 2003. Many of these userforms are outdated and
now amount to clutter and add code bloat. I always thought that I could just
export them but they seem to stay in the project.



All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com