PC Review


Reply
Thread Tools Rate Thread

Alphabetize Macros in a module

 
 
CLR
Guest
Posts: n/a
 
      12th May 2010
Hi All........
I have a module with nearly 100 small macros in it. Is there any way to
automatically alphabetize their order in the module by their name?

TIA
Vaya con Dios,
Chuck, CABGx3


 
Reply With Quote
 
 
 
 
CLR
Guest
Posts: n/a
 
      17th May 2010
Hello Jan Karel.....
I responded to you post the other day but still do not see it posted so will
do it again.

Many thanks for your suggestion......it solved my problem completely.

I much appreciate your help.

Vaya con Dios,
Chuck, CABGx3


"Jan Karel Pieterse" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Clr,
>
>> I have a module with nearly 100 small macros in it. Is there any way to
>> automatically alphabetize their order in the module by their name?

>
> Get hold of MZ tools, it has an option to sort them.
> http://www.mztools.com/v3/download.aspx
>
> Regards,
>
> Jan Karel Pieterse
> Excel MVP
> http://www.jkp-ads.com
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run all macros in module with one command pwk Microsoft Excel Programming 1 15th Feb 2009 02:20 PM
2 Macros running on same module Travis Microsoft Excel Worksheet Functions 2 6th May 2008 12:46 PM
Does 'has module' need to be set to true on forms to run macros? =?Utf-8?B?Q01USA==?= Microsoft Access Form Coding 7 22nd Jun 2007 04:09 AM
compile error in hidden module: macros Tommy Madsen via OfficeKB.com Microsoft Excel Crashes 0 2nd Jun 2005 07:21 AM
Two Macros-One Module =?Utf-8?B?QnVsYU1hbg==?= Microsoft Excel Misc 2 16th Dec 2004 01:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:13 AM.