+ Reply to Thread
Results 1 to 3 of 3

Save macros to a new workbook .

  1. #1
    Forum Contributor
    Join Date
    12-12-2017
    Location
    New Zealand
    MS-Off Ver
    Ms Office 2016
    Posts
    430

    Question Save macros to a new workbook .

    Hello all ,

    I want to save quite a few macros from different w/books to just one new workbook . Is this possible ??? .

    Im using excel 2007 version and the only way i know how is to save them in notepad but sometimes when i copy them to a book the macro,s code lines move a little .

    Ok for small macros but i have some complex ones too .

    Thanks .
    I am grateful for all answers to my questions .
    Also i give a reputation even if not answered .

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Save macros to a new workbook .

    Here is a tutorial on how to achieve what you are looking for. Experienced Excel users employ this technique.

    https://www.rondebruin.nl/win/personal.htm
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    12-12-2017
    Location
    New Zealand
    MS-Off Ver
    Ms Office 2016
    Posts
    430

    Re: Save macros to a new workbook .

    Thank you , will read this over .

+ 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] How to allow others to use edit and save a workbook with lots of Macros
    By TBM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2019, 02:13 PM
  2. Can't save Workbook with macros after changes
    By IrinaKr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2014, 07:35 AM
  3. Delete macros from workbook on save
    By Pedro1803 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2013, 04:31 AM
  4. Open New Workbook with VBA & Save Name & Location for Use in Other Macros
    By amyxkatexx in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-03-2010, 02:26 PM
  5. Save a copy of workbook without macros
    By nnram123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2009, 07:45 AM
  6. [SOLVED] How do I save a workbook as a new workbook by using macros?
    By KingKarl in forum Excel General
    Replies: 4
    Last Post: 11-10-2005, 04:40 AM
  7. Macros on workbook close and save
    By Ade P in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2005, 07:07 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