Mysterious standard toolbar

[Rob Martin]

Hi,

A colleague and I have come to our wits end with the following issue.
We have inherited a VBA (Excel) app that was created with Excel 95.
It uses a customization of the standard toolbar that is apparently a
part of the workbook file. When the file is opened, a single, custom
menu is available on the standard toolbar; all of the standard menu
items (e.g., File, Edit, View, etc.) are gone. This is the case even
when macros are disabled. I've tried everything to remove it from the
workbook file ("Save as", removing all VBA modules, removing all
worksheets, etc.) I've opened the file in a binary editor and changed
the menu name successfully, so I know where it is in the file. I just
cannot force the file to open with the standard (i.e., reset) contents
for standard toolbar. As a workaround, I reset the toolbar from the
auto open subroutine, but this doesn't keep the bastardized toolbar
from showing up when the file is opened with macros disabled. I got a
hint, from a previous posting on this group, that the menu editor from
excel 95 saved menu customizations with the xls file. I suspect
backwards compatibility with 95 is biting me.

Since I have workarounds, this is not a vital problem. It is just
curious and it drives me crazy not understanding exactly why this is
happening. Any insight would be welcome.

TIA
Rob

 

[JWolf]

Excel 5.0 and earlier used the "Menu Editor" to build menus. This is no
longer available in versions newer than 5.0. You can't use the "delete"
method or "reset" to get rid of the custom menu items(as you have learned).

To get rid of the custom menu download Jim Rech's REMOVEMENUS.ZIP file from
Stephen Bullen's site. See instructions and d/l file from:

http://www.bmsltd.ie/MVP/Default.htm

Thanks to Gord and Norman for tipping me.

JWolf

 

[Rob Martin]

Excel 5.0 and earlier used the "Menu Editor" to build menus. This is no
longer available in versions newer than 5.0. You can't use the "delete"
method or "reset" to get rid of the custom menu items(as you have learned).

To get rid of the custom menu download Jim Rech's REMOVEMENUS.ZIP file from
Stephen Bullen's site. See instructions and d/l file from:

http://www.bmsltd.ie/MVP/Default.htm

Thanks to Gord and Norman for tipping me.

JWolf

Rob Martin wrote:

Wow! Thanks for the quick response and valuable info. Removemenus
worked great and its documentation pointed us to the juicy, Excel file
format documentation at openoffice.org.

Thanks again,
Rob