Disable automatic toolbars

[SFOTyke]

I'm using Office XP. I have a spreadsheet with Hyperlinks
to cell ranges in other spreadsheets. When I click the
link the other spreadsheet opens with the cells
highlighted as I require, but Excel always automatically
opens extra toolbars. I don't want these toolbars as they
just take up extra screen real estate. How do I turn this
option off?

 

[Beth Melton]

Which toolbars automatically display?

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[SFOTyke]

Usually the Web Toolbar and the Reviewing Toolbar. There
may be more, but I can't remember.

 

[Beth Melton]

That's what I suspected.

You can kill both toolbars so the no longer surface with this macro:

Sub KillToolbar()
'Change "Reviewing" to "Web" for Web toolbar
With CommandBars("Reviewing")
'Change False to True to enable the toolbar
.Enabled = False
End With
End Sub

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/