Only show one tab in a new workbook.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

skoeske - 06 May 2008 18:33 GMT

Every new workbook opens with three worksheets (tabs)...how many times do you
need three worksheets in a workbook?? I'd rather create my own when I need
them. Just give me one worksheet.

Reply to this Message

Gord Dibben - 06 May 2008 18:48 GMT

Microsoft has already given you that option.

Tools>Options>General>Sheets in new workbook.

Change to 1 and close then re-open Excel.

Gord Dibben MS Excel MVP

>Every new workbook opens with three worksheets (tabs)...how many times do you
>need three worksheets in a workbook?? I'd rather create my own when I need
[quoted text clipped - 8 lines]
>
>http://www.microsoft.com/office/community/en-us/default.mspx?mid=57862b0f-455a-4
bb2-8ff9-f8add4e08113&dg=microsoft.public.excel.setup

Reply to this Message

skoeske - 06 May 2008 18:58 GMT

Yes, I know how to do that but I get worksheets from other people that aren't
as savy and it's really annoying. If Microsoft set up the default as that it
would be most helpful.

> Microsoft has already given you that option.
>
[quoted text clipped - 16 lines]
> >
> >http://www.microsoft.com/office/community/en-us/default.mspx?mid=57862b0f-455a-4
bb2-8ff9-f8add4e08113&dg=microsoft.public.excel.setup

Reply to this Message

Gord Dibben - 06 May 2008 20:42 GMT

If you find that really annoying, I would surmise you have a great life and
certainly no teenagers living at home<g>

I think of it as a bump on a flea's butt in comparison with a few other
annoyances I can think of.

Gord

>Yes, I know how to do that but I get worksheets from other people that aren't
>as savy and it's really annoying. If Microsoft set up the default as that it
[quoted text clipped - 20 lines]
>> >
>> >http://www.microsoft.com/office/community/en-us/default.mspx?mid=57862b0f-455a-4
bb2-8ff9-f8add4e08113&dg=microsoft.public.excel.setup

Reply to this Message

Rate this thread: