Help saving a macro for public use

[kpangman]

Hey all! :hi::rofl: I wrote a macro I want my colleagues to be able to use. We have a shared server but when they open the files I created for them to use the macro on they cant find the saved macro. I have tried saving it to normal.dotm - but it says that its a read only. Also, when I try to select the organizer button within the macro pop up, my saved macro isnt listed. Any advice or help?! :bug::rotlaugh: Thank you all so much!!!!:hi::rofl:

[SamT]

You can always Export the module the code is in as a *.bas file and they can Import that *.bas into their own normal.docm

[gmayor]

By default macros are saved in the normal template. If you want others to be able to share it then it needs to be saved in a macro enabled global template used as an add-in.
Add-in templates go in the user's Word startup folder. If you have not changed the preferred startup folder it can be located (in English language versions of Windows) by typing
%appdata%\Microsoft\Word\Startup
in the Windows File Explorer Address bar and pressing Enter. This folder is individual to the user.
The Normal template is always open when Word is open. If your global template is also open, you can cut and paste macros from the normal project to the template project.
The Normal template should never be read only and should never be shared between users. It is a personal file.

[kpangman]

Strangely SamT this didnt work - any advice?

[SamT]

gmayor is our resident Word expert, see his post.

[Paul_Hossler]

gmayor is our resident Word expert, see his post.


One of many that hang out here