Create macro for "Ctrl + [" shortcut key??

N

nilsstyf

I normally use the "Ctrl + [" shortcut key to jump to a Precedent
reference in a formula/link, however I recently moved to Sweden where
the keyboard layout is different and I am unable to find this shortcut
and have been unable to create a macro for this function.

Does anyone know how to get around this problem using a keyboard with a
different layout (I've already tried changing keyboard layout and
language settings) or does anyone know how to create a macro which
replicates this function??? (I've already tried using the "Edit - Go To
- Special - Precedent" function, however it does not work when the
reference/precedent is in another worksheet/workbook)

HELP!!!!

Thanks,
Nils
 
P

Peo Sjoblom

Get a Swedish keyboard, the shortcut is the same Ctrl + [
you need to hold down AltGr and the [ is at the same key as 8
since the Swedish alphabet has 3 extra letters the place where the [ is on
US layout
is taken already..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top