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?

Under Tools go to options then click the Edit tab and make sure that the
"Show Insert Options Buttons" is checked.



"Sally" wrote in message
...
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?

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?

I would suspect you have the workbook protected.

ToolsProtectionUnprotect workbook.

In 2007 ReviewUnprotect workbook.


Gord Dibben MS Excel MVP

On Wed, 27 Jan 2010 10:24:03 -0800, 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?

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
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?

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?

By workbook protection I don't mean password to open protection.

I mean ReviewProtect 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
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?