Sort Macros alphabetically

[chromachem]

We have over 100 macros in our worksheet. We would like to sort the macros in the vb editor so that they are in alphabetical order.

Thanks

[StephenR]

I thought they were automatically arranged alphabetically?

Ah, are you talking about macros in the same module?

[chromachem]

The drop down box for selecting the macro to edit has the macros in alphabetical order. The macros where you code are in the order they were created. I would like to be able to scroll through the macro code itself in order of the macro name.

Please Login or Register  to view this content.

What I am trying to do is sort the macros so they appear in the editor in order of macro name.

[StephenR]

I don't know how to do that, but one workaround would be to put only one macro in each module, and name the module the same as the macro.