Ctrl F disappeared

[mit]

I have a user using Excel 2000 (from office 2000) and a couple of days ago
he lost the ctrl F function (brings up a find box), it is not hardware
related because other users can use his machine and they don't have a
problem and his account settings have not been changed.

Is there an unrecorded way of turning it on and off??

Tim

 

[Dave Peterson]

I'd try this:

Open excel
test ctrl-F to see if it works (just in case)
if it doesn't work, hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
application.OnKey "^f"


Maybe there's a macro that's trying to steal that shortcut key--or just trying
to kill it.

You can use these two sites to try to find that macro:

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

ps. While you're working on the solution, remind the user that ctrl-h will
bring up the Edit|Replace dialog and you can click on the find tab.

 

[mit]

Thanks Dave I will try that on Monday when I am back behind a desk

Tim