ExcelBanter - Assigning a Hyperlink to a Macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Assigning a Hyperlink to a Macro (https://www.excelbanter.com/excel-discussion-misc-queries/2043-assigning-hyperlink-macro.html)

Paul

Assigning a Hyperlink to a Macro

I am using Excel 2003.

Is it possible to assign a hyperlinked cell to a macro within the same
workbook?

Paul

Frank Kabel

Hi
not really sure what you're trying to achieve. What should happen exactly?

--
Regards
Frank Kabel
Frankfurt, Germany
"Paul" schrieb im Newsbeitrag
...
I am using Excel 2003.

Is it possible to assign a hyperlinked cell to a macro within the same
workbook?

Paul

Paul

when you select the hyperlink, the macro would run.

"Frank Kabel" wrote:

Hi
not really sure what you're trying to achieve. What should happen exactly?

--
Regards
Frank Kabel
Frankfurt, Germany
"Paul" schrieb im Newsbeitrag
...
I am using Excel 2003.

Is it possible to assign a hyperlinked cell to a macro within the same
workbook?

Paul

Frank Kabel

Hi
have a look at the FollowHyperlink event of your worksheet then for this

--
Regards
Frank Kabel
Frankfurt, Germany
"Paul" schrieb im Newsbeitrag
...
when you select the hyperlink, the macro would run.

"Frank Kabel" wrote:

Hi
not really sure what you're trying to achieve. What should happen
exactly?

--
Regards
Frank Kabel
Frankfurt, Germany
"Paul" schrieb im Newsbeitrag
...
I am using Excel 2003.

Is it possible to assign a hyperlinked cell to a macro within the same
workbook?

Paul

All times are GMT +1. The time now is 12:29 PM.