Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
userform to remove from view [email protected] Excel Programming 2 January 12th 07 07:16 AM
Remove Picture from Image1 on a Userform Abdul[_2_] Excel Programming 1 October 3rd 06 02:12 PM
Remove link to another workbook George Gee New Users to Excel 6 January 9th 05 11:24 PM
Remove Userform Deactivate Button Martin Excel Programming 1 September 27th 04 03:20 PM
Remove UserForm lostthought Excel Programming 4 August 13th 04 12:20 AM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"