ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   can we start form by clicking hiperlink ? (https://www.excelbanter.com/excel-programming/280569-can-we-start-form-clicking-hiperlink.html)

Konrad[_4_]

can we start form by clicking hiperlink ?
 
can we start form by clicking hiperlink ?

Hiperlink in one of the sheet's cells. Just it.
might be wery easy but I don't know how to do it.


Tks :)

Konrad

Dick Kusleika[_3_]

can we start form by clicking hiperlink ?
 
Konrad

You can use the Worksheet_FollowHyperlink event. Create a hyperlink that
points to the cell in which it resides (so that it effectively does
nothing), then use the FollowHyperlink event to show the form.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Konrad" wrote in message
...
can we start form by clicking hiperlink ?

Hiperlink in one of the sheet's cells. Just it.
might be wery easy but I don't know how to do it.


Tks :)

Konrad





All times are GMT +1. The time now is 08:03 PM.

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