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

Actually, the default behavior of F11 is to insert a chart sheet, not
worksheet. It is possible that you had an add-in that trapped for F11 and
inserted a worksheet not a chart sheet.

The following code will set F11 to insert a worksheet rather than a Chart
sheet.



"laineywolff" <(E-Mail Removed)> wrote in message
news:3D9E0937-1050-42E8-93D1-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
news:3D9E0937-1050-42E8-93D1-(E-Mail Removed)...
> 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

Chip,
Sorry to bother you, but I am a novice with excel coding, how do I insert
the code into the sheet for it to work?

"Chip Pearson" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:3D9E0937-1050-42E8-93D1-(E-Mail Removed)...
> > 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
>

F11 inserts a chart. Shift+F11 inserts a new worksheet

Tyro

"laineywolff" <(E-Mail Removed)> wrote in message
news:3D9E0937-1050-42E8-93D1-(E-Mail Removed)...
> 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

Maybe you hit shift-F11 to get the new worksheet and you're memory is going
<vbg>.

Chip Pearson has a list of shortcuts here:
http://cpearson.com/excel/KeyboardShortcuts.htm

But I can never remember those keys (except for a couple--it's hell getting
old!).

So I've added a couple of icons to my favorite toolbar:
Tools|Customize|Toolbars tab|create a new toolbar if you like
then
On the Commands Tab|Insert category|drag the Worksheet icon to that favorite
toolbar.

I also dragged an icon from the Forms category--it was the Toggle Grid icon.
Then I can show/hide those gridlines really easily.



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

--

Dave Peterson