Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language being displayed and the tools that are used to create and debug procedures. Microsoft technical support engineers can explain the functionality of a particular procedure. However, they will not modify these examples to provide greater functionality or create procedures that meet your specific requirements.
Although there is no built-in tool for alphanumeric ordering sheets, charts, Microsoft Excel 4.0 macro sheets, and dialog sheets in a workbook, you can do this with a macro.
NOTE: In Microsoft Office Excel 2007 and in earlier versions of Microsoft Excel, you can not sort the macro sheets because they are displayed in the Visual Basic Editor.
For greater ease you can use the spreadsheet with the following format, please use one of the following formats that suit your use: