Re: Show/Hide Functions/Formulas

If you change to a USA keyboard, does it work?

Is your keyboard programmable? Have you programmed this key (or is it set up to
do something by default)?

(I don't have any guesses.)

Smirnoff wrote:

Have tried changing keyboard setting from UK Extended to just UK
keyboard. Ctrl+` toggle still doesn't work.
Can't figure out how selecting Tools>Formula Auditing>Formula Auditing
mode works but the key combination doesn't.
Have searched web but cannot find any references to problem. This is
driving me nuts.

"Smirnoff" <someone@xxxxxxxxxxxxxx> wrote in message
news:BEAF8436-2061-4615-9ECD-8187209FEE5F@xxxxxxxxxxxxxxxx
Have just tried that, same result I'm afraid.

I certainly don't remember assigning/creating a macro with this key
combination.
Have looked in Tools>Macros>Macros....... and there is none listed.

Thanks anyway.


"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:4717AAC1.4B6BEB89@xxxxxxxxxxxxxxxxxxx
I use a USA keyboard, so this is just a guess.

If you close excel and reopen it in safe mode, does ctrl-` work ok?

Close excel
windows start button|Run
excel /safe
Type in a formula and test it.

If that works ok, then maybe you have a macro that's been assigned to
that
combination of keys.

Smirnoff wrote:

For some reason the keyboard shortcut (Ctrl+`) does not toggle
show/hide
function.

Selecting Tools>Formula Auditing>Formula Auditing mode works fine.

I am wondering if it is because I have regional (keyboard) settings
set
to UK English Extended.

I know the `(grave) key works and have tried it with both Ctrl keys
with
no luck.

Help please.

--

Dave Peterson



--

Dave Peterson
.