New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

hyperlinkopen after confirmation of msgbox thorugh yes no

Macros, VBA, Excel Automation, etc.

hyperlinkopen after confirmation of msgbox thorugh yes no

Postby pawandyawa » Mon Feb 29, 2016 2:32 am

hi all,
i need your help in getting the code for below query,

i want to know the code for opening an hyperlink after the mesbox confirmation such as yes no
(52 cells and each cell contains web hyperlink)
if we click on vbyes then hyperlink should open or it should stop.
but the problem is iam using hyperlinkopen event and after clicking the cell it is directly taking me to hyperlink and not waiting for my answer in msgbox.


please help.
  • 0

pawandyawa
Rookie
 
Posts: 2
Joined: Feb 29, 2016
Reputation: 0
Excel Version: excel 2010

Re: hyperlinkopen after confirmation of msgbox thorugh yes no

Postby NoSparks » Mon Feb 29, 2016 12:20 pm

Perhaps if you have a look at this.
Failing that, post a sample workbook with the code you currently have bringing up the message box.
  • 0

NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 90 guests