Prev: Separating data in a column
Next: Summing cell values based on the value of another
From: Sally on 27 Jan 2010 13:24
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 27 Jan 2010 13:31
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 27 Jan 2010 14:00
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 27 Jan 2010 14:56
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 27 Jan 2010 14:58
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?

 |  Next  |  Last
Pages: 1 2
Prev: Separating data in a column
Next: Summing cell values based on the value of another