+ Reply to Thread
Results 1 to 8 of 8

How to delete a module?

  1. #1
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    How to delete a module?

    Hello,

    I inserted a second module into a project. Now I want to delete it. Only i can't figure out how to do this. I highlite it and right click or click edit from the toolbar but i'm provided no options. I can't drag it to the trash either.

    How do you delete a module?


    Thanks!
    Last edited by CrazyFileMaker; 05-25-2009 at 02:12 AM.

  2. #2
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    Re: How to delete a module?

    Nevermind.

    I had to delete all code in the module before given the option to remove it. Nice safety feature.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: How to delete a module?

    You can delete a module by right clicking it in the VB Editor then choosing Remove Module, you can then given the option to export it to save a copy or simply remove it. You don't need to delete the code first.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Re: How to delete a module?

    Hi there,

    and is that possible to remove couple of different module listed in one workbook? I am trying to highlight them all using standard ctr + file option but has no effect...

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How to delete a module?

    Hi,

    You must remove them one at a time.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  6. #6
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Re: How to delete a module?

    try this
    Please Login or Register  to view this content.
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  7. #7
    Registered User
    Join Date
    12-06-2012
    Location
    Tampa Florida
    MS-Off Ver
    Excel 2003 or 2010
    Posts
    5

    Re: How to delete a module?

    Your response has worked for me for years. However, I must have fat-fingered something because now the "Remove Module" is no longer an option. Any suggestions?

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to delete a module?

    Quote Originally Posted by tampacountryboy View Post
    Your response has worked for me for years. However, I must have fat-fingered something because now the "Remove Module" is no longer an option. Any suggestions?
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1