Forgot to post the code.
Sub SetF11()
Application.OnKey "{F11}", "InsertWorksheet"
End Sub
Sub ResetF11()
Application.OnKey "{F11}"
End Sub
Sub InsertWorksheet()
ActiveWorkbook.Worksheets.Add
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"laineywolff" wrote in message
...
At other locations using Excel 2003 I was able to insert a new worksheet
into
the workbook in which I was working by pressing F11. Where I work now,
when
I press F11 it inserts a chart not a worksheet. Do you know how I can
reset
the default so that F11 will insert a worksheet?
Thanks,
laineywolff