Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
Automatic Toolbar
Hello, I posted this question on Excel.Misc a while ago, but everyone
ignored it, I'm really desperate for a solution... any ideas: I use hyperlinks to other documents, but I don't want the Web toolbar to come up everytime I use them.Can I switch that automatic feature off? I don't want to know how to turn a toolbar off (I've done that a thousand times)! I want to know how to stop it from coming on automatically each time I follow a hyperlink. Any ideas? Please... M |
#2
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
Automatic Toolbar
thanks Bill, I think that's fixed it!
M "Bill Manville" wrote in message ... 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 |
#4
Posted to microsoft.public.excel, microsoft.public.excel.links,microsoft.public.excel.misc, microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
Automatic Toolbar
ah, such a relief to not have that damn toolbar opening every time I
use a hyperlink. Thanks Bill (and Michelle for asking the question) Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Toolbar | Excel Discussion (Misc queries) | |||
Automatic Toolbar | Setting up and Configuration of Excel | |||
Disable the automatic reviewing toolbar in Excel | Excel Discussion (Misc queries) | |||
Turn off automatic toolbar | Setting up and Configuration of Excel | |||
Toolbar for automatic series fill?? | Excel Discussion (Misc queries) |