Hi Joseph,
A comprehensive article about distributing macros in a reliable way:
http://www.jkp-ads.com/Articles/DistributeMacro00.htm
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"IBT Employee" wrote in message ...
| Good Morning Everyone!
|
| I have a quick question regarding the distribution of macros.
|
| In the office where I am located we have employees who aren't exactly as
| computer literate as we'd like them to be. Therefore, giving them
| instructions on how to manually input the provided code into the VBA editor
| would be tedious and time consuming.
|
| I'm wondering if there is a way to neatly package these macros and deliver
| them across a network of employees, such as a .exe file of some sort. I know
| that you can create buttons to execute the macro, so I'm thinking that if I
| create an Excel file with the buttons and some instructions it'll work out,
| but will the macro code be sent along with the Excel file?
|
| Thanks for the help!!
|
| -Joseph, IBT Employee