+ Reply to Thread
Results 1 to 2 of 2

Remove Macro from worksheet Excel 2010

  1. #1
    Forum Contributor
    Join Date
    06-11-2018
    Location
    Lebanon, NH
    MS-Off Ver
    2000 and 2010
    Posts
    106

    Remove Macro from worksheet Excel 2010

    Good Morning,
    I have completed a project and need to remove a macro I had saved in several of the worksheets as I could not make it do what I needed it to by saving to the workbook. Now i need to send copies out to a handful of individuals and want to remove that macro from the worksheets in their copies. I've searched the web extensively and I can find ways to delete macros from a workbook and ways to delete a worksheet with macros inserted in it. Maybe I'm using wrong search words...
    I've yet to find an answer to my issue.
    I appreciate any input or suggestions!
    Thanks,
    Bill

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,747

    Re: Remove Macro from worksheet Excel 2010

    The file is a .xlsm file. Save it as a .xlsx file and all the macros will be removed.

    If you just want to remove specific macros and leave others, you just have to delete the code from those modules.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] Excel Macro to Remove Extra Clutters from the Entire Worksheet
    By arnel_10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2017, 04:44 PM
  2. Macro In Protected Worksheet In Excel 2010
    By Goodstart14 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2013, 08:13 PM
  3. Import a list from SharePoint 2010 into an Excel 2010 worksheet
    By nivoe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2013, 05:41 AM
  4. Excel 2010 Macro to copy worksheet, update formula and rename worksheet
    By madmak0203 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:18 PM
  5. Macro to insert new row in Excel 2010 table (ListObject) in protected worksheet
    By kinsley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2012, 02:57 PM
  6. Importing data from an Excel 2010 worksheet into a Word 2010 form.
    By Kuriakos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 02:49 PM
  7. Excel 2010 Macro -how to split worksheet into multiple files
    By kbustin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-01-2012, 10:39 AM

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