Re: Show/Hide Functions/Formulas

Yes, changed to US and worked OK.
Seem to remember another poster saying that Ctrl+` worked fine with his
UK settings.
Fortunately, I have the Formula Auditing mode button in the toolbar, I
wouldn't want to keep changing settings.

However, I notice that in Control Panel>Regional
Settings>Languages>Details>Settings, if you highlight one of the
installed services and click Add or Remove, you can choose an input
language AND a keyboard layout.
Perhaps I should try UK English input language with US keyboard layout.
Christ they do make it complicated.
Thanks for your help and would appreciate any further comments



"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:4718998A.6313B9CD@xxxxxxxxxxxxxxxxxxx
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


.