How do I remove F12 as the keyboard shortcut for Save As in Excel

[Anthony_at_Gilsbar]

Removing F12 for Save As in Word 2003 was very simple but the instructions in
Word is not the same in Excel 2003. Tools menu > Customize > Keyboard
button...so forth

 

[Dave Peterson]

Maybe you could remove that F12 key???

Or just remove the spring underneath the key???

But you could use a couple of macros (one to disable and one to enable):

Option Explicit
Sub disableF12()
Application.OnKey "{f12}", ""
End Sub

This would toggle it back to normal.

Sub enableF12()
Application.OnKey "{f12}"
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Anthony_at_Gilsbar]

I like a since of humor. I did the macro and that works. Is there a way to
run the macro when Excel opens so the user does not have to do the ctrl key
sequence to run the macro?

 

[Dave Peterson]

You could create a dedicated workbook, put the code in that workbook.

But rename them:

Option Explicit
Sub Auto_Open()
Application.OnKey "{f12}", ""
End Sub
Sub Auto_Close()
Application.OnKey "{f12}"
End Sub

Auto_Open will run when the workbook opens. Auto_Close will run when the
workbook closes.

Then save that new workbook with the macro in your XLStart folder (use windows
search to locate that folder).

Lots of people have their own customized workbooks with lots of macros like
this. They'll usually name this file personal.xls.

But if you're going to share it with others, you could name it
AnthonyUtils.xls

Then you don't have to worry about stepping on their files if they want both
open at the same time.

 

[Anthony_at_Gilsbar]

Thanks Dave!! I will try this on Monday. Have a good weekend!