+ Reply to Thread
Results 1 to 3 of 3

Make copy of xlsm

  1. #1
    Registered User
    Join Date
    03-15-2012
    Location
    Stavanger, Norway
    MS-Off Ver
    Excel 2016
    Posts
    77

    Make copy of xlsm

    Hello!

    I have a excel workbook with macros in it. I`m trying to make a copy as backup, but in the copy, every macro does`nt work. Is there are special way to copy macro enabled workbook? Thanks for any reply!

    Br Ossa

  2. #2
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: Make copy of xlsm

    Hi Br Ossa,

    maybe you tried to save as xlsx which does not allow the use of macros. Try it like this:

    Please Login or Register  to view this content.
    Regards

    Theo
    Remember To Do the Following....
    1. Upload sample files
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Registered User
    Join Date
    03-15-2012
    Location
    Stavanger, Norway
    MS-Off Ver
    Excel 2016
    Posts
    77

    Re: Make copy of xlsm

    Hello!

    Thanks for reply .I tried your code, and it did make a copy. But still the macros are not working. Any ideas...

+ 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