Macro

[wrbmab]

Can I create a macro in one of my spreadsheets and send it to another user so
they could use it on their adta in their computer?

 

[Jacob Skaria]

Yes you can. The macro code is stored within the workbook itself...

 

[wrbmab]

Jacob, thanks for the info. I asked the wrong question. We receive a data
spreadsheet at multiple work stations each morning. I have created a macro to
sort this data and put it into the format we want to see it in. Is it
possbile to give this macro to the other users/workstations in my area. I
hope this makes sense, sorry for the confusion.

 

[Otto Moehrbach]

If I understand you correctly, yes. A macro is simply text. You can send
it to anyone by any means, email, mail, etc. They will have to properly
install it in their workbook, however. If they do that, the macro will work
fine. HTH Otto

 

[Gord Dibben]

Place the macro in a module of a new workbook.

Save As>File Type>MS Excel Add-in

Place the add-in in a folder accessible to all users on your network.

Instruct them on how to load the add-in.


Gord Dibben MS Excel MVP