Inserting a new Worksheet
 

i have an Excel file which already has about 7 worksheets, and i want to add
another one and the 'insert worksheet' option is grayed out and i don't know
why. how can i fix this?

Inserting a new Worksheet
 

Some Protection set?

cRooKsy09 wrote:

i have an Excel file which already has about 7 worksheets, and i want to add
another one and the 'insert worksheet' option is grayed out and i don't know
why. how can i fix this?

Inserting a new Worksheet
 

Could be the Workbook...........not Worksheet......... is protected under
ToolsProtection.


Gord Dibben MS Excel MVP

On Wed, 6 Jun 2007 08:16:01 -0700, cRooKsy09
wrote:

i have an Excel file which already has about 7 worksheets, and i want to add
another one and the 'insert worksheet' option is grayed out and i don't know
why. how can i fix this?

Inserting a new Worksheet
 

Look at the workbook protection options. Also look at whether the file is
read-only.
--
David Biddulph

"cRooKsy09" wrote in message
...
i have an Excel file which already has about 7 worksheets, and i want to
add
another one and the 'insert worksheet' option is grayed out and i don't
know
why. how can i fix this?