MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sharing a macro


Posted by Chris D on January 03, 2002 3:19 AM

Hi all,

I just set up a quick n easy macro and assigned a shortcut key to it, saved in personal.xls

now my boss wants it - is it possible to make it available to all our Excel users ? (in a perfect world even with the same shortcut key ?)

many thanks
Chris
:-)


Posted by Dank on January 03, 2002 4:29 AM

You could save it as an add-in in a shared folder. Then get your users to click Tools, Addins, the Browse to the add-in. This has the advantage that if you want to make changes to the workbook then you've only got to do it in one place.

Regards,
Daniel.

Posted by Chris D on January 03, 2002 5:03 AM

Thanks Daniel,

How would I save it as an add-in ?

I have VBE open....

thanks
Chris

Posted by Chris D on January 03, 2002 5:42 AM

Done it via JWalk book.... thanks again though ! (NT)


Posted by Dank on January 03, 2002 5:43 AM

Go into normal Excel view. Click File, Save As and choose a file type of Add-in. Easy eh? You need to be careful that your code doesn't contain any 'Thisworkbook' references. If you find any, change them to ActiveWorkbook.

Any other probs, let me know.

Regards,
Daniel.