Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default attach macro to hyperlink

Hello All,

Is it possible to attach a macro to a hyperlink. If the
answer is yes, how would I do it?

Thanks in advance,
Rohit
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default attach macro to hyperlink

Dave,

Thanks very much for the response. It's works just the way
I wanted it to.

Rohit
-----Original Message-----
Maybe you can use the event: Worksheet_FollowHyperlink

But it'll fire after the link gets started.

(Rightclick on the worksheet tab that contains the

hyperlink (the hyperlink is
in a worksheet???), select view code and then select

worksheet in the left hand
header and followhyperlink in the right hand header.

Put a little msgbox in there to see if it comes close to

what you want.


Rohit Thomas wrote:

Hello All,

Is it possible to attach a macro to a hyperlink. If the
answer is yes, how would I do it?

Thanks in advance,
Rohit


--

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
HOW TO AUTOMATICALLY ATTACH A DOC TO AN EMAIL USING A HYPERLINK Justin New Users to Excel 1 April 21st 08 10:05 PM
Attach macro to a cell Marco Excel Discussion (Misc queries) 4 October 31st 07 12:22 AM
Can you attach, hyperlink or embed Email Items in a SS? JustBreathe Excel Worksheet Functions 0 June 4th 07 10:11 PM
How to attach an excel workbook to an email using a hyperlink? Wk Excel Discussion (Misc queries) 1 January 20th 06 01:44 AM
De-Attach Macro?? Is there any way? marika1981 Excel Discussion (Misc queries) 13 January 8th 05 03:13 PM


All times are GMT +1. The time now is 12:55 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"