(Step by Step) - To add new macros to (Dropdown Menu) in 2003 Excel Sheet

' -------------------------------------------------------------------------------------------------------

' [01] - open macros of the list of vbaproject

' [02] - Info steps

' [03] - Sub WB_50_Menu_Maker() - click and run

' [04] - ------------------------------------------------------------------------------------------------

' [05] - Look on Sheet9 - column F should be selected - right-click and copy

' [06] - Goto - zzzz_goto_Ref - Should be open

' [07] - Now scroll - goto to the "stop here"

' [08] - Right above the "stop here" - go up to the Emd Sub

' [09] - Now Select all the data above and starting with End Sut to the top of page

' [10] - Just Select End Sub - Then use the button to the right and scroll to top

' [11] - Now using "shift-key" click mouse just left of the Sub WB_menu_1 everything should be selectd

' [12] - Hit backspace or Delete - Now Right-click and click Paste

' [13] - ------------------------------------------------------------------------------------------------

' [14] - Now go back to Sheet9 - and on "WB_50_ListMacros_zzzz"

' [15] - Next:

' [16] - Now on the macro that opened

' [17] - Click by the beginning of "Sub WB_50_ListMacros_zzzz()"

' [18] - Hit Run or the Arrow - give it time to finish the process

' [19] - ------------------------------------------------------------------------------------------------

' [20] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

' [21] - Now right-click on the selected column B - and select copy

' [22] - ------------------------------------------------------------------------------------------------

' [23] - Now - Goto - zzzz_goto_Ref - on the macro screen

' [24] - Next:

' [25] - Now Scroll down a little and select the top "Sub zzzzz_goto_"

' [26] - Now Scroll down to bottom and Hit the "shift key" click right at at the end of "End Sub"

' [27] - Should all be Selected - backspace or hit delete

' [28] - ------------------------------------------------------------------------------------------------

' [29] - Now in macro screen - at the top - Click "Debug" - click "Compile_VbaProject"

' [30] - Now it might give error - on the blue highlighted click the end - just put a 2 at end

' [31] - Now in macro screen - at the top - Click "Debug" click "Compile_VbaProject"

' [32] - This is double checking - just repeat the process if needed

' [33] - ------------------------------------------------------------------------------------------------

' [34] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

' [35] - Click on "WB_50_Del" button - and look up a little should see the numbers disappear

' [36] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

' [37] - Click on "WB_50_Open" button - and look up a little should see the numbers reappear

' [38] - ------------------------------------------------------------------------------------------------

' [39] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

' [40] - Now - at the bottom of screen - Right-click on Sheet at left of Sheet1 - and select delete - say-yes at the bottom of screen -

' [41] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

' [42] - Now click on "ListMacros_Make_Hyperlink" - let process finish

' [43] - Now go back to Sheet9 by clicking on the main big blue part of excel - should Active screen

' [44] - Now Click near the left and top of screen - Click on "DupB"

' [45] - Now in macro screen - at the top - Click to the left - "Sub Duplicates_sbFindDuplicatesInColumnB_leave_cell_blank"

' [46] - Now click "Run run or the arrow"

' [47] - And Select Cell "C1" - Now - holding down the - Control-key & shift-key - arrow down

' [48] - Should see a duplicate - no bigggg-e

' [49] - Now at the bottom left of Main screen Right-Click on the 2 files left of "Sheet1" and delete both

' [50] - Should be complete - unless - haha

' -------------------------------------------------------------------------------------------------------