Ask Your Question

copy a spreadsheet with macros to another pc

asked 2017-11-20 14:18:56 +0200

psafaris gravatar image

I have created a spreadsheet with two macros which are in standard on my own pc but I want a colleague to be able to use a copy of the spreadsheet on their pc. If I copy the file to his pc the macros don't work.

edit retag flag offensive close merge delete


Hello @psafaris,

Please make sure that your colleague also has the same two macros in their Standard library.

librebel gravatar imagelibrebel ( 2017-11-20 15:06:07 +0200 )edit

The question I was asking was how do I get the macros onto my colleague's machine. I found a way of doing it. I copy the macro basic code to a text file and then opened the standard library on their machine and copied the text file in. Somewhat inelegant but it worked.

psafaris gravatar imagepsafaris ( 2017-11-21 11:08:40 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-11-20 18:15:08 +0200

pierre-yves samyn gravatar image


If the macros are in the Standard library, it's probably because they are not dedicated to a particular spreadsheet. ToolsMacrosOrganize does not export the Standard Library of "My Macros", hence the question ...

  • Either you create a library in My Macros and move your macros there (and you can use ToolsMacrosOrganizeOrganizerLibraries tab to export/import)
  • Or you use the StandardExportImport.odt (see here) created by Bernard Marcelly for this purpose (I have not tested but Bernard's codes are a reference).

HTH - Regards

edit flag offensive delete link more


Thanks - this would have been helpful if I had not solved the problem by copying the macro basic code to a text file and then copying that code into the standard library on my colleague's machine

psafaris gravatar imagepsafaris ( 2017-11-21 11:12:15 +0200 )edit

answered 2017-11-20 17:10:52 +0200

peterwt gravatar image

Create a library in the spreadsheet and put the macros there. Then the colleague will have them in the calc file.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-20 14:18:56 +0200

Seen: 512 times

Last updated: Nov 20 '17