Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 73
Default Hyperlink dialog

Can someone please tell me how to open the Insert Hyperlinks dialog box. I
presume it is one of the built-in dialogs?

Thanks
Fred


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,080
Default Hyperlink dialog

Application.Dialogs(xlDialogInsertHyperlink).Show

The Immediate Window is a great help in answering questions like this!

--

Vasant

"Fred" <leavemealone@home wrote in message
...
Can someone please tell me how to open the Insert Hyperlinks dialog box. I
presume it is one of the built-in dialogs?

Thanks
Fred




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Hyperlink dialog

Fred,

Application.Dialogs(xlDialogInsertHyperlink).Show

It doesn't appear to be available in XL 97.

Jim Cone
San Francisco, USA


"Fred" <leavemealone@home wrote in message
...
Can someone please tell me how to open the Insert Hyperlinks dialog box. I
presume it is one of the built-in dialogs?

Thanks
Fred


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Hyperlink dialog

Just checked and it does work in xl97.

Jim Cone


"Jim Cone" wrote in message
...
Fred,
Application.Dialogs(xlDialogInsertHyperlink).Show
It doesn't appear to be available in XL 97.
Jim Cone
San Francisco, USA



"Fred" <leavemealone@home wrote in message
...
Can someone please tell me how to open the Insert Hyperlinks dialog box. I
presume it is one of the built-in dialogs?

Thanks
Fred


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 73
Default Hyperlink dialog

Thanks Jim,
yes I was using XL97 and xlDialogInsertHyperlink is not listed anywhere in
help files but it does work.


"Jim Cone" wrote in message
...
Fred,

Application.Dialogs(xlDialogInsertHyperlink).Show

It doesn't appear to be available in XL 97.

Jim Cone
San Francisco, USA


"Fred" <leavemealone@home wrote in message
...
Can someone please tell me how to open the Insert Hyperlinks dialog box.
I
presume it is one of the built-in dialogs?

Thanks
Fred




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
Remove content of last visited pages in "Insert Hyperlink" dialog Excel bloke Excel Worksheet Functions 4 June 12th 06 12:37 AM
Force *relative* path in Insert Hyperlink dialog Mark Tangard[_3_] Excel Programming 3 January 17th 05 02:48 PM
Disable Dialog when following external hyperlink John Tolman[_2_] Excel Programming 2 November 7th 04 07:33 AM
Hyperlink to open a common dialog on a msgbox Harinath Excel Programming 1 April 28th 04 03:33 PM
Display the Hyperlink Dialog when inserting Hyperlinks Tommo[_2_] Excel Programming 2 February 23rd 04 02:11 AM


All times are GMT +1. The time now is 05:03 AM.

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"