how to make a link to a function or subroutine...
 

Hi, I have an spreadsheet with some VBA code with functions and
routines...

I'd like to call those subroutines or functions clicking a cell, or
some text of the cell. (like a hiperlink).

I don't want to use buttons, or the click event of cells...

I guess I could write a kind of function like =HYPERLINK ... that I
could call like this:

=MakeLink(sub-to-run,text-to-display-in-cell)

I'll appreciate your ideas..
regards,

JPC

how to make a link to a function or subroutine...
 

Your idea doesn't meet the criteria you state:

I'd like to call those subroutines or functions clicking a cell, or
some text of the cell. (like a hiperlink).

the only macro activity generated by clicking a cell is the activity in the
click event or by an actual hyperlink.

--
Regards,
Tom Ogilvy



"Pablo Chemes" wrote in message
om...
Hi, I have an spreadsheet with some VBA code with functions and
routines...

I'd like to call those subroutines or functions clicking a cell, or
some text of the cell. (like a hiperlink).

I don't want to use buttons, or the click event of cells...

I guess I could write a kind of function like =HYPERLINK ... that I
could call like this:

=MakeLink(sub-to-run,text-to-display-in-cell)

I'll appreciate your ideas..
regards,

JPC

how to make a link to a function or subroutine...
 

Thanks.

I've tried what you said and worked fine...
but then I found another workarround:

I've set the desired Cell to be a hyperlink... to the same sheet and cell
and in the followhyperlink event I've wrote the call to the code I needed.

Thanks again.
JPC

"Tom Ogilvy" wrote in message ...
Your idea doesn't meet the criteria you state:

I'd like to call those subroutines or functions clicking a cell, or
some text of the cell. (like a hiperlink).

the only macro activity generated by clicking a cell is the activity in the
click event or by an actual hyperlink.

--
Regards,
Tom Ogilvy



"Pablo Chemes" wrote in message
om...
Hi, I have an spreadsheet with some VBA code with functions and
routines...

I'd like to call those subroutines or functions clicking a cell, or
some text of the cell. (like a hiperlink).

I don't want to use buttons, or the click event of cells...

I guess I could write a kind of function like =HYPERLINK ... that I
could call like this:

=MakeLink(sub-to-run,text-to-display-in-cell)

I'll appreciate your ideas..
regards,

JPC