Thread: Automatic Toolbar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
Bill Manville Bill Manville is offline
external usenet poster
  
Posts: 473
Default Automatic Toolbar
A VBA solution which would prevent the Web toolbar from being shown (at
all) would be:
Application.CommandBars("Web").Enabled = False

If you wanted to disable it only when a particular workbook was open
you could put this in its Workbook_Open procedure in ThisWorkbook
and
Application.CommandBars("Web").Enabled = True
in Workbook_BeforeClose

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply With QuoteReply With Quote