Macro: movo to sheet ( content of a cell)? is it possible?

[SpeeD]

hi guys!

I have a problem.

I intend to make a "central" workshhet with hiperlinks to
all other sheets, but the "Name" of the other sheets is
changeble, so my plans just doesn´t work because the
hiperlink´s aren´t "Dinamic", after he name change they
don´t point the sheet.

Now i just want to make a Macro that "move me" to a sheet
determine by the content of a cell. Is it possible??

thanks a lot guys!
SpeeD

 

[Tim Otero]

You actually do not need a macro for this...Use the hyperlink function. For
example, I tested this in cell A1 with the path in C5 (derived by formula)
and the file name in D5 (derived by formula):

=HYPERLINK(C5&"\"&D5,D5)

Works perfectly...

tim
hi guys!

I have a problem.

I intend to make a "central" workshhet with hiperlinks to
all other sheets, but the "Name" of the other sheets is
changeble, so my plans just doesn´t work because the
hiperlink´s aren´t "Dinamic", after he name change they
don´t point the sheet.

Now i just want to make a Macro that "move me" to a sheet
determine by the content of a cell. Is it possible??

thanks a lot guys!
SpeeD