Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2012, 09:44 PM
New Daddy New Daddy is offline Resorting macros in alphabetic order? Windows Vista Resorting macros in alphabetic order? Office 2003
Advanced Beginner
Resorting macros in alphabetic order?
 
Join Date: Jan 2012
Posts: 90
New Daddy is on a distinguished road
Default Resorting macros in alphabetic order?

I've been using macros for over a decade, but it never occurred to me that sorting macros in alphabetic order in the VBA editor would help locating what I want.



So, how do I do it?
Another question is, is there any reason Word doesn't sort the macros in alphabetic order in the VBA editor?
Reply With Quote
  #2  
Old 02-06-2012, 06:05 AM
macropod's Avatar
macropod macropod is offline Resorting macros in alphabetic order? Windows 7 64bit Resorting macros in alphabetic order? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi New Daddy,

So far as Word is concerned, the order in which macros are stored in a module is inconsequential. Indeed, I'd be annoyed if that happened to some of the code I write, as in some projects I want to group macros together by function, not by name - and in any event these macros are typically hidden from the macros dialogue. Regardless of the sort order in the vbe, visible macros appear sorted in the macros dialogue. If you want to sort them, it's a matter of manual cut & paste.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sort word text in alphabetic order . crossing Word 8 01-20-2012 09:51 AM
Resorting macros in alphabetic order? Contact order djchapple Outlook 5 09-08-2011 11:42 AM
Resorting macros in alphabetic order? Change order of names to LAST / FIRST ? Jack R Outlook 1 07-05-2010 08:50 PM
Resorting macros in alphabetic order? Reversing Text Order weemikey Word 4 08-05-2009 11:10 AM
Resorting macros in alphabetic order? Order of Service sparky3883 Word 1 11-17-2008 11:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft