How do I remove a UserForm from a workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi, Bill:

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

Thanks,

George
 
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,

In the VBE Explorer, right-click on the userform and select "Delete UserformName"

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why is my UserForm event procedure disapeared? 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Activate a moacro subroutine from a userform command button 1
Open UserForm From A Different Workbook 17
Live chart in a userform 6
Copy a userform to a different workbook with VBA 5
Userform from a Userform Problem 1
Excel 2013 one userform directing activity in many workbooks 0

Back
Top