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?