View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Robert Robert is offline
external usenet poster
 
Posts: 193
Default How to make toolbars static with IE7

I wanted to let you know that there are two work-arounds.

1. Once the grid is exported and the IE7 browser has instantiated Excel, the
user can right-click on the tab bar just to the right of the last tab (the
"New Tab" tab) and select "Show Document Tools" and the Excel toolbars that
the user has selected as the defaults within Excel itself will be shown. As
far as I can tell, this option only appears when exporting to an Office
Product.

As an aside, the toolbar selections that are subsequently shown are located
in the user's Excel*.xlb file (the "*" represents the version of Excel and
will change based on the version of Excel installed on the PC, e.g., in my
case, I have "Microsoft Office Excel 2003 (11.8120.8122) SP2" so my file is
Excel11.xlb). There are lots of entries on the web on how to reset the .xlb
file if it becomes corrupted.

2. The second method is user-specific and involves forcing the grid to Excel
rather than to a new instantiation of the browser. This is detailed in
Microsoft Knowledge Base article 162059 at
http://support.microsoft.com/?scid=162059. The article lists two methods. One
is a Registry change but the other is much easier because it uses the Windows
Folder Tool. See the article for details. (Thanks to Dave Peterson for this
information).

Robert