Prev: Separating data in a column
Next: Summing cell values based on the value of another
From: Sally on 28 Jan 2010 12:17
Thank you for the suggestions.

The workbook & worksheets are not protected.
The Show Insert Option button is checked.
The Allow editing in cell is checked.
The Show sheets tab is checked.
Under Format - Visibility Unhide sheet is grayed out.

Any other suggestions?

Thank you. Sally

"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 28 Jan 2010 15:05
By workbook protection I don't mean password to open protection.

I mean Review>Protect Workbook.

Is that what you looked at?

Other than that I have no help.

If workbook is Shared you can Insert a sheet but not delete it.


Gord

On Thu, 28 Jan 2010 09:17:01 -0800, Sally <Sally(a)discussions.microsoft.com>
wrote:

>Thank you for the suggestions.
>
>The workbook & worksheets are not protected.
>The Show Insert Option button is checked.
>The Allow editing in cell is checked.
>The Show sheets tab is checked.
>Under Format - Visibility Unhide sheet is grayed out.
>
>Any other suggestions?
>
>Thank you. Sally
>
>"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?

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