Vba to go to another sheet in same workbook
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.
|