Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-08-2014, 09:39 AM
JustAboutNoon JustAboutNoon is offline Triggering event on hyperlink notifying user before redirecting Windows 8 Triggering event on hyperlink notifying user before redirecting Office 2013
Novice
Triggering event on hyperlink notifying user before redirecting
 
Join Date: Oct 2014
Posts: 4
JustAboutNoon is on a distinguished road
Default Triggering event on hyperlink notifying user before redirecting


I have no experience using VBA, but I am comfortable with javascript and open to learning. Just wanted to check that there was not already an easy solution to this that I am missing, before I dedicate time to learning something big.

Is any good way to trigger an alert window (i.e. a user prompt or popup) when someone clicks a particular hyper link. So that, for example, the hyperlink could say: "The referenced document has been attached to this memo as appendix 1, to continue to the original online version please please click "Continue" otherwise x out of this box." And then have the user be redirect (as a normal hyperlink would be) to the page, if they click continue.
Reply With Quote
  #2  
Old 10-16-2014, 05:56 PM
CoolBlue's Avatar
CoolBlue CoolBlue is offline Triggering event on hyperlink notifying user before redirecting Windows 7 64bit Triggering event on hyperlink notifying user before redirecting Office 2013
Advanced Beginner
 
Join Date: Jun 2014
Location: Australia
Posts: 40
CoolBlue is on a distinguished road
Default Triggering event on hyperlink notifying user before redirecting

I assume you are talking about a hyperlink in an excel document. You can make a macro in vba and put the name of the macro in the hyperlink where the link address would normally go. The macro will be fired when you hover the mouse pointer over the link.
=IFERROR(HYPERLINK(MyMouseOverEvent(),"Click here"), "Click here")
Reply With Quote
  #3  
Old 10-16-2014, 07:58 PM
macropod's Avatar
macropod macropod is offline Triggering event on hyperlink notifying user before redirecting Windows 7 64bit Triggering event on hyperlink notifying user before redirecting Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by CoolBlue View Post
I assume you are talking about a hyperlink in an excel document.
I don't know why you'd assume a question about intercepting hyperlinks via VBA in a Word VBA forum on a board that also has an Excel Programming forum has anything to do with Excel or that an Excel formula would be appropriate...

As it is, Word has no hyperlink event to trap. Consequently, anything that might be done in that regard (if possible) would probably have to be done through the Windows API.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 10-16-2014, 08:41 PM
CoolBlue's Avatar
CoolBlue CoolBlue is offline Triggering event on hyperlink notifying user before redirecting Windows 7 64bit Triggering event on hyperlink notifying user before redirecting Office 2013
Advanced Beginner
 
Join Date: Jun 2014
Location: Australia
Posts: 40
CoolBlue is on a distinguished road
Default

Haha... My bad... I came here via a search and didn't notice which forum it was. Its not so clear in this app. Thanks for the heads-up.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving appointments from one user's calender to another, with the ability for user to samgraham1975 Outlook 0 02-04-2014 07:20 PM
Triggering event on hyperlink notifying user before redirecting SlideShows - Triggering Animation, Sound & Video pgrant PowerPoint 3 03-27-2013 12:28 PM
Triggering event on hyperlink notifying user before redirecting Manually Triggering Animations on One Slide cjphil57 PowerPoint 2 03-05-2013 10:50 PM
Triggering event on hyperlink notifying user before redirecting Insert the Hyperlink and hide all sheets except clicking Hyperlink PRADEEPB270 Excel 1 02-22-2013 09:47 AM
Triggering event on hyperlink notifying user before redirecting Redirecting emails sdminus Outlook 3 07-12-2008 09:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft