From: Sally on
I have created a workbook with 7 worksheets. I want to add more worksheets
but the option to Insert Worksheets is grayed out. What have I done to
remove this option from just this workbook?
From: ruic on
Under Tools go to options then click the Edit tab and make sure that the
"Show Insert Options Buttons" is checked.



"Sally" <Sally(a)discussions.microsoft.com> wrote in message
news:8A26C97C-0A01-48A1-88D0-7F7EF23F87A1(a)microsoft.com...
>I have created a workbook with 7 worksheets. I want to add more worksheets
> but the option to Insert Worksheets is grayed out. What have I done to
> remove this option from just this workbook?


From: Donna on
Make sure you don't have any of the sheets grouped

"מיכאל (מיקי) אבידן" wrote:

> Maybe: 'Tools' > 'Protection' > Remove WorkBook Protection'/
> Micky
>
>
> "Sally" wrote:
>
> > I have created a workbook with 7 worksheets. I want to add more worksheets
> > but the option to Insert Worksheets is grayed out. What have I done to
> > remove this option from just this workbook?
From: Gord Dibben on
I would suspect you have the workbook protected.

Tools>Protection>Unprotect workbook.

In 2007 Review>Unprotect workbook.


Gord Dibben MS Excel MVP

On Wed, 27 Jan 2010 10:24:03 -0800, Sally <Sally(a)discussions.microsoft.com>
wrote:

>I have created a workbook with 7 worksheets. I want to add more worksheets
>but the option to Insert Worksheets is grayed out. What have I done to
>remove this option from just this workbook?

From: Gord Dibben on
You can still insert sheet in group mode.

You will insert as many new sheets as you have grouped.


Gord Dibben MS Excel MVP

On Wed, 27 Jan 2010 11:00:16 -0800, Donna <Donna(a)discussions.microsoft.com>
wrote:

>Make sure you don't have any of the sheets grouped
>
>"????? (????) ?????" wrote:
>
>> Maybe: 'Tools' > 'Protection' > Remove WorkBook Protection'/
>> Micky
>>
>>
>> "Sally" wrote:
>>
>> > I have created a workbook with 7 worksheets. I want to add more worksheets
>> > but the option to Insert Worksheets is grayed out. What have I done to
>> > remove this option from just this workbook?