I have been using Excel 2003 to produce spreadsheets for others to use which necessitated deleting menu items from the standard menu bar. I now need to update this code for use with Excel 2010.
Here are examples of the type of thing I was doing in Excel 2003 (via auto_open) ... which worked fine.
When the application closed (via auto_close), I used the code:
to reset the menus.
I realised these lines of code would not be correct for Excel 2010, so I tried the following:
… but to no avail. The code is accepted (well there are no complaints), but nothing happens. The menu items are still visible when I open the application.
Can anyone help please. TIA
….. Andre Francis
Bookmarks