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 Office/Excel 2003 - Stop toolbars automatically opening

I was having a problem in Office XP with links to other
spreadsheets. Every time I clicked a link and opened
another spreadsheet, the Web and Review toolbars would
open. I inserted the follwoing code in each Workbook and
it solved the problem:

Sub Workbook_Open()

' Hide the "Web" and "Reviewing" Toolbars/Commandbars

Application.CommandBars("Web").Visible = False
Application.CommandBars("Reviewing").Visible = False

End Sub

I have now upgraded to Office 2003 and the Web toolbar
still opens, even though the code is there. Any ideas?


 
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
Opening Office 2003 excel file in Office Excel 2007 Joel Excel Discussion (Misc queries) 1 July 3rd 09 05:56 AM
Stop Excel from automatically opening the last file esilverb Excel Discussion (Misc queries) 1 May 27th 09 04:31 PM
Opening an Office 2003 Excel doc with Office 2000 NT Roxy Excel Discussion (Misc queries) 4 February 8th 08 10:54 PM
Opening an Office 2007 Excel file in Office 2003 charstachura Excel Discussion (Misc queries) 1 November 8th 07 09:36 PM
How do I stop excel automatically opening in e-mail format? roberrt stephen hawker Excel Discussion (Misc queries) 1 August 3rd 05 04:06 PM


All times are GMT +1. The time now is 10:32 PM.

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"