ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to keep web tool bar turned off in Excel-It keeps reappearing (https://www.excelbanter.com/excel-discussion-misc-queries/178478-how-keep-web-tool-bar-turned-off-excel-keeps-reappearing.html)

Dennu

How to keep web tool bar turned off in Excel-It keeps reappearing
 
I keep clicking the web tool bar off, but it keeps reappearing when I go back
and forth from the same files that I have opened and have clicked the web
toolbar off

Dave Peterson

How to keep web tool bar turned off in Excel-It keeps reappearing
 
If you never use that toolbar, you could just enter a command from the VBE
immediate window:

Hit alt-f11
hit ctrl-g
type this and hit enter:
Application.CommandBars("web").Enabled = False
And close this window and try it out.

Change False to True when you decide you want it back.

Dennu wrote:

I keep clicking the web tool bar off, but it keeps reappearing when I go back
and forth from the same files that I have opened and have clicked the web
toolbar off


--

Dave Peterson


All times are GMT +1. The time now is 12:55 PM.

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