Thread: VBA Macro Dist.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown[_4_] Gary Brown[_4_] is offline
external usenet poster
 
Posts: 209
Default VBA Macro Dist.

I would suggest creating an Add-in with the macros.
When the Add-in is loaded, have it create a top menu item with all your
macros listed for easy reference by your not quite literate fellow employees.
John Walkenbach has some great books that reference Add-ins.
'Power Programming with VBA':
For 2003, see...
http://j-walk.com/ss/books/xlbook25.htm
For 2007, see...
http://j-walk.com/ss/books/index.htm

John's general site is...
http://www.j-walk.com/

--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"IBT Employee" wrote:

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