ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Web toolbar comes on by itself when opening a file (https://www.excelbanter.com/excel-programming/371488-web-toolbar-comes-itself-when-opening-file.html)

quartz[_2_]

Web toolbar comes on by itself when opening a file
 
I am using Office 2003 on Windows XP.

I have a program that interacts with many files, opens them for viewing,
sometimes performs an action, etc.

Some files when opened automatically cause the Web toolbar to display, which
is annoying enough, but it is also floating over the spreadsheet blocking the
view.

Apart from coding something to see if the toolbar is visible, and then
turning it off, how can I kill this activity? I mean surely there is a way to
switch it off???

Thanks in advance.

JLGWhiz

Web toolbar comes on by itself when opening a file
 
Are you sure that some of the files you call are not web based windows?

"quartz" wrote:

I am using Office 2003 on Windows XP.

I have a program that interacts with many files, opens them for viewing,
sometimes performs an action, etc.

Some files when opened automatically cause the Web toolbar to display, which
is annoying enough, but it is also floating over the spreadsheet blocking the
view.

Apart from coding something to see if the toolbar is visible, and then
turning it off, how can I kill this activity? I mean surely there is a way to
switch it off???

Thanks in advance.


skatonni[_2_]

Web toolbar comes on by itself when opening a file
 
Try:
CommandBars("Web").Enabled = False

See details he
http://word.mvps.org/faqs/macrosvba/...WebToolbar.htm

"quartz" wrote:

I am using Office 2003 on Windows XP.

I have a program that interacts with many files, opens them for viewing,
sometimes performs an action, etc.

Some files when opened automatically cause the Web toolbar to display, which
is annoying enough, but it is also floating over the spreadsheet blocking the
view.

Apart from coding something to see if the toolbar is visible, and then
turning it off, how can I kill this activity? I mean surely there is a way to
switch it off???

Thanks in advance.



All times are GMT +1. The time now is 06:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com