Resetting Menu Bars in Visual Basic
 

I don't think I've ever seen that error message. Could it be another macro
sending you the message?

(and if your .reset statement is in the ThisWorkbook module, try:

application.commandbars("....").reset



Peter Hutchinson wrote:

Using CommandBars("Worksheet Menu Bar").Reset appears to
work until I come to close Excel. Then I get a message box
saying "Microsoft Excel - Routine Location Error Code:2 -
Please record this error code"

Does anyone know how to get rid of this error message?

--

Dave Peterson