Inserting a new Worksheet

C

cRooKsy09

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?
 
G

Gord Dibben

Could be the Workbook...........not Worksheet......... is protected under
Tools>Protection.


Gord Dibben MS Excel MVP
 
D

David Biddulph

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