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.

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.
--
Gary''s Student - gsnu200779


"Mali" wrote:

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.

great thx worked perfectly!!!!

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200779


"Mali" wrote:

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.