View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default 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