+ Reply to Thread
Results 1 to 4 of 4

Remove certain modules before saving a copy of workbook as new name

  1. #1
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Remove certain modules before saving a copy of workbook as new name

    I need a way to remove cetain modules before saving a copy the current workbook with out lossing an of the modules on the main workbOok

    Bramz
    Bramz

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,013

    Re: Remove certain modules before saving a copy of workbook as new name

    Either 1) Delete the modules, use SaveAs to save a copy, Close the original without saving changes
    Or 2) use SaveAs to save a copy, then Delete the modules from the copy, resale the copy.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Remove certain modules before saving a copy of workbook as new name

    The main workbook creates and saves x amount of versions so it would have to be the second way...

    I have found a way to remove modules butt not sure how to get macro to work ho i need it to......

    Please Login or Register  to view this content.
    Please excuse any and all typos i am working with a pc that is offline and posting via android tablet with a bluetooth keyboard that has been washed and dryed twice (not sure how its still functioning)

  4. #4
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Remove certain modules before saving a copy of workbook as new name

    Admin please remove this post browser double posted
    Last edited by meabrams; 10-09-2016 at 04:25 AM. Reason: double post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove Workbook Password when Saving a Copy for Distribution
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2015, 04:51 AM
  2. Replies: 7
    Last Post: 07-05-2013, 01:23 PM
  3. Replies: 0
    Last Post: 09-07-2012, 10:48 AM
  4. Remove all code and modules from the active workbook
    By dasvas in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-09-2011, 11:26 PM
  5. Copy all modules to another workbook
    By Coaster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2010, 02:03 PM
  6. Copy VBA Modules To Another Workbook
    By strato1983 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2010, 02:56 PM

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