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

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

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

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 wrote:

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

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

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" wrote:

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 wrote:

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

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

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 wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson

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

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

"Dave Peterson" wrote:

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 wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson