keyboard keypress action macro

[icestationzbra]

hi folks,

i have a bunch of tabs (over a dozen) within a large workbook. the first sheet is the index sheet with table of contents, links and all that kind of stuff.

i was wondering if there is a way to capture a unique set to keyboard keypresses (say, ALT+Home) to trigger the index sheet to come up in case the user is on another sheet. as new tabs are being added, it is becoming increasingly difficult to quickly jump to the index sheet.

thanks in advance for any pointers.

best regards.

[TMS]

Why not just put hyperlinks on each page?

Regards

[Dom83]

Hi,

Use the application.onkey method for this:

Please Login or Register  to view this content.

Cheers,
Dom

[icestationzbra]

hi dom,

i tried doing that by pasting the whole code in Module1, but it does not seem to be doing the trick. i have tried putting it in other places to, that does not work either.

would you be able to share an excel file which has this working, please?

much thanks and regards.

[watersev]

hi, icestationzbra, please check attachment, save and open workbook, activate any sheet except Index Sheet and press "Alt+Home".Closing this workbook resets this key combination action. The codes are in workbook module and a standard module.

[icestationzbra]

works like a charm, waterserv. much obliged.

thanks and regards.