Vba to go to another sheet in same workbook

[Mali]

hi i need to use code to move to a different sheet in a woorkbook. i can do
this by using assign hyperlink to a shape object...but i want to also have
some code that does something in the new sheet when this object is clicked.

i've tried assign hyperlink and then assign a macro to the same object..in
that case the hyperlink works byt the macro doesnt seem to work. which is why
ifigured if i could put the hyperlionk in the code then both will work.

any help would be much appreciated.

 

[Gary''s Student]

Don't bother to put a hyperlink in the VBA. If you are already in the macro,
then just:

Sheets("Sheet5").Activate

will take you to a new sheet as easily as the hyperlink would.

 

[Mali]

great thx worked perfectly!!!!

Don't bother to put a hyperlink in the VBA. If you are already in the macro,
then just:

Sheets("Sheet5").Activate

will take you to a new sheet as easily as the hyperlink would.