I'd like to Add a new menu item to the Worksheet Menu Bar. The caption on the new menu should be Cost Statement. Within the new menu item, I'd like to add the following buttons.
Caption: Reset Report
Caption: Locate Missing IDs
The new menu item needs to be added in when the ThisWorkbook opens, and the worksheet menubar is to be reset each time ThisWorkbook closes.
Any help would be highly appreciated.
PS: ThisWorkbook is a normal excel file (xls) - Not an Add-in