Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Imnotageek
 
Posts: n/a
Default Why can't I use the Enter key to go to the file in a hyperlink in.

In Excel 2003 I can't use the Enter key to to to a hyperlink destination. It
only works with a mouse click.

Also how do I stop the Web toolbar appearing everytime I go to the hyperlink
destination.

These are both very annoying changes in Excel 2003.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

I think that excel's behavior changed before xl2003 (for the hyperlink stuff).
(and I don't have a solution for you)...

One way is to just to disable the Web toolbar until you want it back.

Option Explicit
Sub testme01()
Application.CommandBars("web").Enabled = False
End Sub

If you want it back, just change the False to True.

You could run that little macro, or you could even just enter the 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.

Imnotageek wrote:

In Excel 2003 I can't use the Enter key to to to a hyperlink destination. It
only works with a mouse click.

Also how do I stop the Web toolbar appearing everytime I go to the hyperlink
destination.

These are both very annoying changes in Excel 2003.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hyperlink file association McMapper Excel Discussion (Misc queries) 0 January 14th 05 05:43 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Hyperlink with Enter key CPA Jammer Excel Discussion (Misc queries) 0 December 22nd 04 03:53 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 04:45 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"