ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Restrictions to hyperlinks (https://www.excelbanter.com/excel-discussion-misc-queries/34413-restrictions-hyperlinks.html)

AndyOne

Restrictions to hyperlinks
 

I have created a basic hyperlink to send a mail. Is it possible to make
a restriction that the hyperlink can no be activated if a cell is not
filled or a check box is not marked?

Thanks!


--
AndyOne
------------------------------------------------------------------------
AndyOne's Profile: http://www.excelforum.com/member.php...o&userid=20217
View this thread: http://www.excelforum.com/showthread...hreadid=385577


Dave Peterson

I don't think so. But maybe you could replace the hyperlink with a button that
executes a macro that does all your validation and then goes off on the
hyperlink.

AndyOne wrote:

I have created a basic hyperlink to send a mail. Is it possible to make
a restriction that the hyperlink can no be activated if a cell is not
filled or a check box is not marked?

Thanks!

--
AndyOne
------------------------------------------------------------------------
AndyOne's Profile: http://www.excelforum.com/member.php...o&userid=20217
View this thread: http://www.excelforum.com/showthread...hreadid=385577


--

Dave Peterson


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com