LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Mysterious standard toolbar

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Standard Toolbar ksal Excel Discussion (Misc queries) 3 January 6th 10 03:57 PM
Changes to standard toolbar Alison Excel Discussion (Misc queries) 5 May 15th 06 11:44 PM
toolbar for "standard tickmarks" mark kubicki Excel Worksheet Functions 0 July 12th 05 07:16 PM
Fax Button on Standard Toolbar Bruce Excel Discussion (Misc queries) 1 April 19th 05 10:35 PM
Standard andFormatiing toolbar GregR Excel Discussion (Misc queries) 0 February 9th 05 12:44 AM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"