View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default How do I set F11 to insert worksheet Excel 2003?

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