hyperlink with check box

[kuzna26]

hey guys on excel I have create 10 different worksheet like sheet 1 to sheet 10,
and on sheet o a have main menu that contains the list of sheets 1, 2 , 3....10
with a check box next to each sheet title. I would like to hyperlink to the appropriate sheet
once I check the box next to its title ..
i.e if I check the box net to sheet 3 it should take me to sheet 3

hope it make sense , any help please

antonio

[Craig K.]

This is really a question for the VBA / Macro forum on this site.
Assuming you added the checkbox as an ActiveX control object, double click on the checkbox and it will open VBA. Enter this code for each checkbox Sub

Please Login or Register  to view this content.

for each checkbox you need to change the checkbox number (in red)and the sheet name (in green).

This code will only take you to the corresponding tab when checking the box.