Macros saved in Personal.xlsb file unusable by others on the server

[logicrulz]

I am new to vba and macros. I saved all the macros I created to personal.xlsb file in an attempt to be able to replicate them at a later date. I then realized that this rendered the macros unusable to the various users of the workbooks on other computers. Can I export the macros to a place on the server to make them available to other users on the workbooks or will I need to recreate the macros and save them in the individual workbooks? Thanks in advance

 

[alansidman]

You can export them to a folder on the server and the others can then import them into their Personal.xlsb files. In the VBE, click on each macro and select file-->export

 

[logicrulz]

Thanks for the reply. Unfortunately the other users aren't comfortable with excel enough to make that solution work. I will probably just rewrite each one and keep it in the workbook so there's no problems. It just requires multiple duplicates on my part over the coarse of time.