Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 *******ized 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Standard Toolbar | Excel Discussion (Misc queries) | |||
Changes to standard toolbar | Excel Discussion (Misc queries) | |||
toolbar for "standard tickmarks" | Excel Worksheet Functions | |||
Fax Button on Standard Toolbar | Excel Discussion (Misc queries) | |||
Standard andFormatiing toolbar | Excel Discussion (Misc queries) |