MrExcel.com - Your One Stop for Excel Tips & Solutions

Function Keys

Posted by Brian on June 05, 2001 11:35 AM

Is there a setting in Escel 2000 or a way to ad a VB code that will disable the function keys (F1 through F12) and (Alt+F1 through Alt+F12). I have a multi sheet workbook application and I don't want the user to inadvertantly activate anything by hitting a Function key.

Thanks

Posted by Damon Ostrander on June 05, 2001 2:29 PM

Brian,

You can set all the function keys using the VBA Application.OnKey method. You can also set the Alt+Function keys. Just set them to something that is a "no op", but don't forget to reset them to their default settings when done.

Damon