| | A | B | C | D | E | F | G |
| 1 | |
PopUpMenu Name | | | |
| http://www.rondebruin.nl/qat.htm |
| 2 | 1 |
MyPopUpMenu | | | | | |
| 3 | | | |
| | | |
| 4 |
Level |
Caption |
Macro name |
Divider |
FaceID | | |
| 5 | 2 |
Char Map | showCharMap | |
1 | |
To identify the FaceID numbers you can download |
| 6 |
2 |
Deletions -- Destructive | |
| | |
John Walkenbach's faceids.xlsbm from my site |
| 7 | 3 |
Convert Hyperlinks | personal.xlsb!ConvertHyperlinks | |
1 | |
http://www.rondebruin.nl/qat.htm |
| 8 | 3 |
DelHyperLinks | personal.xlsb!DelHyperLinks | |
1 | | |
| 9 | 3 |
Delete Empty Rows | personal.xlsb!DelEmptyRows | |
| | |
| 10 | 3 |
delShapesOnSht | personal.xlsb!delShapesOnSht | |
1 | | |
| 11 | 3 |
MakeLastCell | personal.xlsb!makelastcell | |
1 | |
After you edit the menu you can press the button "Refresh Menu" |
| 12 | 3 |
RemoveEmptyModules (Colo) | personal.xlsb!RemoveEmptyModules |
| | |
to create the new menu and show it. |
| 13 | 3 |
Delete Unused (Debra's lastcell) |
personal.xlsb!DeleteUnused_endingrows_all_sheets | | |
| |
| 14 |
2 |
Informative -- Msgbox type stuffn |
Informative -- Msgbox type stuffn | | | |
Button for [Refresh Menu] |
| 15 | 3 |
FormulaBox | personal.xlsb!FormulaBox | |
1 | | |
| 16 | 3 |
WhereAmI | personal.xlsb!WhereAmI | |
1 | | |
| 17 |
2 |
Listings -- Destructive/Documentation |
Listings -- Destructive/Documentation | | | |
|
| 18 | 3 |
BuildTOC_A3 | personal.xlsb!BuildTOC_A3 | |
1 | |
If it is Ok click the "Hide Save" button to hide the workbook and Save the workbook. |
| 19 | 3 |
Command Bar List (CB_List) | personal.xlsb!CB_List | |
1 | | |
| 20 | 3 |
FormulaIntoComments | personal.xlsb!FormulasIntoComments |
| 1 | |
Button for [Hide and Save] |
| 21 | 3 |
Get Shaps Proc | personal.xlsb!getShapeProc | |
1 | | |
| 22 | 3 |
List Functions and Subs | personal.xlsb!ListFunctionsAndSubs |
| 1 | | |
| 23 | 3 |
EnumerateAddins | personal.xlsb!EnumerateAddIns | |
1 | | |
| 24 | 3 |
Enumerate Sheets_95 | personal.xlsb!EnumerateSheets_XL95 |
| 1 | | |
| 25 | 3 |
ReOrderSheets -- Reorders Sheet Tabs |
personal.xlsb!ReOrderSheets | | 1 |
| |
| 26 | 2 |
Mark Cells | personal.xlsb!MarkCells | |
1 | | |
| 27 | 2 |
Mark Sep Areas | MarkSepAreas | |
1 | | |
| 28 |
2 |
Create Simulated Data | | |
| | |
| 29 | 3 |
Random 003 | personal.xlsb!Random003 | | |
| |
| 30 | 3 |
Random A-Z | personal.xlsb!RandomAZ | | |
| |
| 31 | 3 |
FillSequence | personal.xlsb!fillsequence | | |
| |
| 32 | 3 |
Mark Sequence | personal.xlsb!MarkSeq | | |
| |
| 33 |
2 |
GoTo Cell, HTML, Hyperlink, Sheet, Sub |
| | | | |
| 34 | 3 |
Go To Cell | personal.xlsb!GoToCell | |
1 | | |
| 35 | 3 |
Go To HTML | personal.xlsb!GoToHTML | |
1 | | |
| 36 | 3 |
Go To Hyperlink | personal.xlsb!GoToHyperLink | |
1 | | |
| 37 | 3 |
Go To Sheet | personal.xlsb!GoToSheet | |
1 | | |
| 38 | 3 |
Go To Sub | personal.xlsb!GoToSub | |
1 | | |
| 39 | 3 |
Sort Worksheet Tabs | personal.xlsb!SortALLSheets | |
1 | | |
| 40 |
2 |
Reformat: Join, |
Reformat: Join, | | | | |
| 41 | 3 |
HTML - xl2HTMLx | personal.xlsb!XL2HTMLx | |
1 | | |
| 42 | 3 |
HTML - xl2HTML | personal.xlsb!XL2HTML | |
1 | | |
| 43 | 3 |
HTML - xl2HTMLs - Miultile Sheets | personal.xlsb!xl2HTMLs |
| 1 | | |
| 44 | 3 |
Clear Clipboard | personal.xlsb!Clear_Clipboard | |
1 | | |
| 45 | 3 |
Fix US Zip 5 | personal.xlsb!fixUSzip5 | |
1 | | |
| 46 | 3 |
Fill Sequence | personal.xlsb!fillsequence | |
1 | | |
| 47 | 3 |
Firstname | personal.xlsb!FirstName | |
1 | | |
| 48 | 3 |
InsertCellReplacement | personal.xlsb!InsertCellReplacement |
| 1 | | |
| 49 | 3 |
Insert Prefix** | personal.xlsb!insertprefix | |
1 | | |
| 50 | 3 |
Join | personal.xlsb!Join | |
1 | | |
| 51 | 3 |
Lastname | personal.xlsb!LastName | |
1 | | |
| 52 | 3 |
Lower_Case | personal.xlsb!Lower_Case | |
1 | | |
| 53 | 3 |
MakeHyperlinks | personal.xlsb!MakeHyperlinks | |
1 | | |
| 54 | 3 |
MakeHyperlinkFormulas | personal.xlsb!MakeHyperlinkFormulas |
| 1 | | |
| 55 | 3 |
Make INDIRECT | personal.xlsb!Make_INDIRECT | |
1 | | |
| 56 | 3 |
Proper_Case | personal.xlsb!Proper_Case | |
1 | | |
| 57 | 3 |
Reenter | personal.xlsb!ReEnter | | | |
|
| 58 | 3 |
Remove Extra Lines Within Cells |
personal.xlsb!Remove_XtraLinesWithinCells | |
1 | | |
| 59 | 3 |
Reversi | personal.xlsb!ReversI | |
1 | | |
| 60 | 3 |
RotateCW (top to bottom) | personal.xlsb!RotateCW | |
1 | | |
| 61 | 3 |
Sep Term | personal.xlsb!SepTerm | |
1 | | |
| 62 | 3 |
Sep Last Term | personal.xlsb!SepLastTerm | |
1 | | |
| 63 | 3 |
Suffix (and Prefix) | personal.xlsb!suffix | | |
| |
| 64 | 3 |
TrimALL | personal.xlsb!TrimALL | |
1 | | |
| 65 | 3 |
Upper_Case | personal.xlsb!Upper_Case | |
1 | | |
| 66 |
2 |
Selections Hyperlinks, Sheets | |
| | | |
| 67 | 3 |
Random 003 | personal.xlsb!Random003 | |
2950 | | |
| 68 | 3 |
IconExplorer.exe -- get icons for toolbars |
personal.xlsb!IconExplorer | | 1 |
| |
| 69 | 3 |
Select Hyperlinks | personal.xlsb!SekectHyperlinks | |
1 | | |
| 70 | 3 |
selShapesOnSht (selective delete) | personal.xlsb!selShapesOnSht |
| 1 | | |
| 71 | 2 |
Buttons that I had | | |
| | |
| 72 | 3 |
Footer, custom | personal.xlsb!PutFilenameInFooter | |
| | |
| 73 | 3 |
/M/ MacroDialogBox | PERSONAL.xlsb!MacroDialogBox | |
| | |
| 74 | 3 |
/R/ RunFromActiveCell | PERSONAL.xlsb!RunSubFromActiveCell |
| | | |
| 75 | 3 |
/S/ Go To Sub | PERSONAL.xlsb!GoToSub | | |
| |
| 76 | 3 |
BackupByDate | PERSONAL.xlsb!backupBYDATE | | |
| |
| 77 | 3 |
XL2HTML | personal.xlsb!XL2HTML | | | |
|
| 78 | 3 |
XL2HTMLx | personal.xlsb!XL2HTMLx | | | |
|
| 79 | 3 |
**Insert Row** | PERSONAL.xlsb!InsertRowsAndFillFormulas_caller |
| | | |
| 80 | 3 |
**Top of Column** | PERSONAL.xlsb!GotoTopOfCurrentColumn |
| | | |
| 81 | 3 |
**Bottom of Column** | PERSONAL.xlsb!GotoBottomOfCurrentColumn |
| | | |
| 82 | 3 |
GotoPrevSheet | PERSONAL.xlsb!GotoPrevSheet | | |
| |
| 83 | 3 |
GotoNextSheet | PERSONAL.xlsb!GotoNextSheet | | |
| |
| 84 | 3 |
/H/ MakeHTML_Link | PERSONAL.xlsb!MakeHTML_Link | |
| | |
| 85 | 3 |
Decode HTML text | PERSONAL.xlsb!decode_html_text | |
| | |
| 86 | 3 |
<> ListFunctionsAndSubs | personal.xlsb!ListFunctionsAndSubs |
| 482 | | |
| 87 | 3 |
/DSht/ DeleteThisSheet | PERSONAL.xlsb!DeleteThisSheet |
| | | |
| 88 | 3 |
StrikeThrough [Ctrl+S] | PERSONAL.xlsb!StrikeThru | |
290 | | |
| 89 | 3 |
/CK/ Clear Constants | PERSONAL.xlsb!Clear_Constants | |
| | |
| 90 | 2 |
Wi&zards TESTING | | TRUE | |
| |
| 91 | 3 |
Wizard Number &1 | MyMacro1 |
| 71 | | |
| 92 | 3 |
Wizard Number &2 | MyMacro2 |
| 72 | | |
| 93 | 3 |
Wizard Number &3 | MyMacro3 |
TRUE | 73 | | |
| 94 | 2 |
&Tools | | | | | |
| 95 | 3 |
Tools Number &1 | MyMacro4 | |
71 | | |
| 96 | 3 |
Tools Number &2 | MyMacro5 | |
72 | | |
| 97 | 2 |
&Printing | | | | | |
| 98 | 3 |
Printing Number &1 | MyMacro6 |
| 4 | | |
| 99 | 3 |
Printing Number &2 | MyMacro7 |
| 4 | | |
| 100 | 3 |
Printing Number &3 | MyMacro8 |
TRUE | 4 | | |
| 101 | 2 |
&Charts | | | | | |
| 102 | 3 |
Charts Number &1 | MyMacro9 |
| 17 | | |
| 103 | 3 |
Charts Number &1 | MyMacro10 |
| 17 | | |
| 104 | 2 |
&Minimize | MyMacro11 | TRUE |
| | |
| 105 | 2 |
Ma&ximize | MyMacro12 | | |
| |
| 106 | 2 |
&Help | | TRUE | | |
|
| 107 | 3 |
&Help Contents | MyMacro13 | |
49 | | |
| 108 | 3 |
&More Help | MyMacro14 | |
351 | | |
| 109 | 3 |
&About | MyMacro15 | TRUE |
| | |