E-mail a macro

[gr026]

Hi

I created a macro, and its saved in the personal list

I want to e-mail the macro to a co-worker - how do I do this?

Thanks

 

[Dave Peterson]

I would take that code and put it into a different workbook. Then save that
workbook as a new name.

If you send them a copy of your personal.xls, then that name may conflict with
their own personal.xls workbook. (Excel can only have on workbook with that
name open at any time.)

You could save the file as GrUtils.xls.
email it to them.
tell them to open that file when they need to run the macro.
tools|macro|macros|and select the macro and run it.

 

[Karsen]

Another way to email a macro to someone else is to open up the Visual
Basic Editor, find and select your macro, copy to the clipboard, then
paste it to an email. Then the receipient "lifts" it from the email
and pastes it to their spreadsheet via the VB Editor.

If you need more info, post a reply here or email me directly.