Inserting sheets into Excel workbook

  • Thread starter Thread starter Sally
  • Start date Start date
S

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?
 
Under Tools go to options then click the Edit tab and make sure that the
"Show Insert Options Buttons" is checked.
 
I would suspect you have the workbook protected.

Tools>Protection>Unprotect workbook.

In 2007 Review>Unprotect workbook.


Gord Dibben MS Excel MVP
 
You can still insert sheet in group mode.

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


Gord Dibben MS Excel MVP
 
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
 
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
 
Back
Top