Providing access to certain macros to all users

[wpanssi]

Is there a way to make certain macros accessible to other users automatically? Of course I can inform users to open a workbook that contains the macros. But it would be better if the users were not required to open the workbook.

I asked the same question here: http://vbaexpress.com/forum/showthread.php?t=23360 but since it wasn't the main question it was left unanswered.

[Bob Phillips]

Create an addin and sitribute that.


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrbuildingapplicationspecificaddins.asp
Building Application Specific Add-Ins

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrexceladdins.asp
Excel Add-Ins

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovraddinstemplateswizardslibraries.asp
Add-ins, Templates, Wizards, and Libraries