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?