Thread: VBA Macro Dist.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default VBA Macro Dist.

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