View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JimRWR JimRWR is offline
external usenet poster
 
Posts: 18
Default Updating Custom Menu Code References when New Workbook is saved

Thanks, Bob, that works. One other question - what property is available for
custom drop down menus? I tried manipulating the type property of the
CommandBarControl object to msoControlButtonDropDown, but get the Invalid
Procedure Call Argument (RTE 5) error.

Jim

"JimRWR" wrote:

Hi.

I'm using custom menu items to load and display forms in an Excel 2000
workbook, Application v1.0 If I save the workbook as Application v2.0 and
click on a menu item to load a form, Excel goes and finds Application v1.0.
How do I programmatically remove these links, so that Application v2.0 will
use the code directly behind that workbook?


TIA,

Jim