Dynamic sheet activation

[a.hudrea]

Hey guys,
I want to activate a sheet based on a cell value. So,I have a list lets say "JAN", "FEB", "MAR" etc and sheets with those exact names also. I thought something like this would work

Please Login or Register  to view this content.

but i'm getting an error "438" object doesn't support this property or method.
Thanks.

[Winon]

Hello a.hudrea,

Why bother with VBA Code if you could use Excel built in feature, like Hyperlinks as demonstrated in the attached sample Workbook?

Regards.

[a.hudrea]

Hi Winon,
Actually this small code is part of a bigger project and I can only do it by VBA Code. Depending on the cell value I need it to go to a certain sheet and change some values then come back to the original sheet.

[nilem]

maybe

Please Login or Register  to view this content.

[a.hudrea]

Nope, sorry same error.

[nilem]

try it

Please Login or Register  to view this content.

[a.hudrea]

Works. Tnx a bunch.