Inserting sheets into Excel workbook

[Sally]

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?

 

[ruic]

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

 

[Donna]

Make sure you don't have any of the sheets grouped

 

[Gord Dibben]

I would suspect you have the workbook protected.

Tools>Protection>Unprotect workbook.

In 2007 Review>Unprotect workbook.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

You can still insert sheet in group mode.

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


Gord Dibben MS Excel MVP

 

[Sally]

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

 

[Gord Dibben]

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