Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
Anytime I click on a hyperlink in Excel, it automatically opens my web
toolbar. Is there a way to stop that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
Dock the Toolbar?
TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
Thanks for your suggestion, but toolbar shows up docked immediately under the
formatting toolbar. "Bob I" wrote: Dock the Toolbar? TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
Do you use the web toolbar at all?
If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
Yes, unfortunately I do use the toolbar from time to time.
"Dave Peterson" wrote: Do you use the web toolbar at all? If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
Maybe you could create your own customized web toolbar (MyWeb). Then disable
excel's. TerryTutor wrote: Yes, unfortunately I do use the toolbar from time to time. "Dave Peterson" wrote: Do you use the web toolbar at all? If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
Didn't work...
The Ctrl-G puts you in the immediate window. This didnt work, even if I restarted Excel. So I put it in the code window. That didnt work because there wasnt a named macro. So I gave the macro (code) a name, did an End Sub at the end. It didnt work, even when I restarted Excel. "Dave Peterson" wrote: Do you use the web toolbar at all? If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
Do you mean that the command you entered in the immediate window (or the sub)
didn't run? Or do you mean that the command ran ok, but didn't do what you wanted? For me (xl2003), the command ran nicely--no errors popped up. And when I went to excel, then tools|Customize|toolbars tab, Web didn't even appear in the list that was displayed. TerryTutor wrote: Didn't work... The Ctrl-G puts you in the immediate window. This didnt work, even if I restarted Excel. So I put it in the code window. That didnt work because there wasnt a named macro. So I gave the macro (code) a name, did an End Sub at the end. It didnt work, even when I restarted Excel. "Dave Peterson" wrote: Do you use the web toolbar at all? If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
It is a hyperlink to a file causing the issue if that helps.
"Dave Peterson" wrote: Do you use the web toolbar at all? If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
I thought that disabling the Web toolbar would stop that toolbar from showing up
-- no matter what the link pointed to. TerryTutor wrote: It is a hyperlink to a file causing the issue if that helps. "Dave Peterson" wrote: Do you use the web toolbar at all? If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
From the person I was trying to help:
Okay, its 4:30 am when things should make no sense. Now it works. I dont understand why it wouldnt work last night. But it works this morning. Thanks for the help! "Dave Peterson" wrote: Do you mean that the command you entered in the immediate window (or the sub) didn't run? Or do you mean that the command ran ok, but didn't do what you wanted? For me (xl2003), the command ran nicely--no errors popped up. And when I went to excel, then tools|Customize|toolbars tab, Web didn't even appear in the list that was displayed. TerryTutor wrote: Didn't work... The Ctrl-G puts you in the immediate window. This didn€„˘t work, even if I restarted Excel. So I put it in the code window. That didn€„˘t€„˘ work because there wasn€„˘t a named macro. So I gave the macro (code) a name, did an End Sub at the end. It didn€„˘t work, even when I restarted Excel. "Dave Peterson" wrote: Do you use the web toolbar at all? If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
I'd bet there was at least one typo in the first efforts.
TerryTutor wrote: From the person I was trying to help: Okay, its 4:30 am when things should make no sense. Now it works. I dont understand why it wouldnt work last night. But it works this morning. Thanks for the help! "Dave Peterson" wrote: Do you mean that the command you entered in the immediate window (or the sub) didn't run? Or do you mean that the command ran ok, but didn't do what you wanted? For me (xl2003), the command ran nicely--no errors popped up. And when I went to excel, then tools|Customize|toolbars tab, Web didn't even appear in the list that was displayed. TerryTutor wrote: Didn't work... The Ctrl-G puts you in the immediate window. This didn€„˘t work, even if I restarted Excel. So I put it in the code window. That didn€„˘t€„˘ work because there wasn€„˘t a named macro. So I gave the macro (code) a name, did an End Sub at the end. It didn€„˘t work, even when I restarted Excel. "Dave Peterson" wrote: Do you use the web toolbar at all? If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clicking hyperlink causes toolbar to show
Thank you Dave that is exactly what I wanted. The Web toolbar was really
getting to me. Even when docked it would still jump down a line when I used a hyperlink (which I do a lot at work). I like having the full path of the file I am working on shown in the address box as we experiment with macros on copies of files before editing the live documents, and it's good to have the quick glance check that I am looking at the right one I nearly made a post about it but I searched an found this first saving me the trouble! Cheers!! "Dave Peterson" wrote: Maybe you could create your own customized web toolbar (MyWeb). Then disable excel's. TerryTutor wrote: Yes, unfortunately I do use the toolbar from time to time. "Dave Peterson" wrote: Do you use the web toolbar at all? If no, then maybe you could disable it: 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. (I didn't test this. Please post back with your results.) TerryTutor wrote: Anytime I click on a hyperlink in Excel, it automatically opens my web toolbar. Is there a way to stop that? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clicking on numbered boxes, plus and minus sign to show and hide d | Excel Discussion (Misc queries) | |||
Eliminate second browse box when right clicking for hyperlink | Excel Worksheet Functions | |||
auto show a line on a chart by clicking on a legend key | Charts and Charting in Excel | |||
How to turn off the popup warning when clicking on a hyperlink | Excel Worksheet Functions | |||
Right clicking on text does not bring up hyperlink option | Excel Discussion (Misc queries) |