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
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
I thought they were automatically arranged alphabetically?
Ah, are you talking about macros in the same module?
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks