Distributing macros to other users

Hi,

I have created an Excel spreadsheet with a few macros that is to be used by a handful of coworkers. I'd like to have them use the spreasheet without lowering their macro security below "High".

To get around this, I created an Add-In (.xla) which was just a blank worksheet with a module containing the the macros. When I enable the add-in on my computer to test it, however, the macros are not found.

My question is, how can I access the macros in the add-in? Or, is there another way that other users can access the macros without lowering their security settings?

I checked into getting a digital signature but that's not worth the cost.

Thanks for both replies. I should have mentioned that the macros work fine if I save the code in a module under my active workbook. However, this will cause a problem because the code is unsigned, therefore disabled with a High security setting.

I have confirmed that the IsAddin property is set to True. Also, the certificate created by SelfCert is not exportable and will only work on my local machine.

Mallycat, I have read that the macros in my .xla will be hidden (not listed) however, when I type the name, the VB editor opens and created a new sub procedure under a new Module in the current workbook.

Ultimately, I was trying to achieve the macro call by a button imbedded in the users workbook. However you mentioned using the toolbar technique which I haven't tried yet. I'll give that a whirl.

Toolbars are much more flexible because they can be used for more than 1 sheet. They are easy to set up too.

Matt

I was able to get the macros working if I used the toolbar method, but only after I lowered my macro security to Medium and then chose to Enable Macros. So the bottom line is that using an Add-In does not get around the digital certificate requirement.