Unable to double click cell without running hyperlink in cell

Radoman

Board Regular
Joined
Jan 31, 2009
Messages
75
Hello

Sorry if this is a silly question!

I have a macro that runs when a cell is double-clicked and some of the cells have hyperlinks, which of course run with a single click.

Right now I'm unable to double click the cell to run the macro, no matter how quickly I do it but I need the hyperlink as well.

Is there any way to keep both operations please?

Thank you!
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Mohammad Basem

Well-known Member
Joined
Dec 24, 2011
Messages
1,218
Hi,

Try increasing the cell's width to extend beyond the text (have empty area at one end) then double click on the empty area of the cell.
 

Radoman

Board Regular
Joined
Jan 31, 2009
Messages
75
I don't believe it, you're right, the solution's so simple.

Many thanks to you!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,509
Messages
5,596,561
Members
414,077
Latest member
ammylar5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top