Share Macro

[Martin]

Question? How do I share a macro in an excel spreadsheet.
The macro I created sorts my "LastName" column in
ascending order. I assigned a command button on the column
to make the sorting easy for users by just clicking the
button. Unfortunately when I share my file the macro
doesn't work. Is there a way I can simplify this?

 

[Jonathan Rynd]

I assigned a command button on the column
to make the sorting easy for users by just clicking the
button.

Do you mean you assigned a command button on the toolbar?

Where is the macro stored?

How are you tranferring the macro to another user?