I saw you post and how do you get the new module to show up in the micro menu
to select it or run it?

"Kevin B" wrote:

Open the workbook that has the macro and press Alt+F11 to open the VBE.
Select the module that has the macro and click on FILE in the menu and select
EXPORT FILE. In the SAVE dialog box select the destination drive/folder and
save the file. The macro module will have the same name as the module itself
with a BAS extension. You can then email the module to your users.

They, in turn, need to open Excel, go to the VBE and click FILE, IMPORT FILE
to incorporate the module. IF they're going to be putting this in their
PERSONAL.XLS file, have them unhide the PERSONAL.XLS file and import the
macro from that file.
--
Kevin Backmann


"cf9034" wrote:

I have created a macro in Excel that I need to share with other users in my
office. I would like to copy this macro to their pc. How can I add this
macro to their macro listing without removing what they currently have?