Problem inserting a new worksheet

N

Nick

I cannot insert additional worksheets into the exisiting book. The option is
faded out, suggesting I might have something locked or otherwise. Can you
help please
 
N

Nick

Hi Ron, I have several pages in the document and I have made sure that they
all unprotected, but they "insert" option remains greyed out
 
G

Gord Dibben

Nick

Ron is speaking of "workbook" protection, not "worksheet" protection.

Tools>Protection>Unprotect Workbook.

Sheet protection just prevents changes to the sheet which is protected.

Workbook protection prevents changes to the workbook, like adding or deleting
a sheet.


Gord Dibben Excel MVP
 
N

Nick

Brilliant, thanks very much all sorted and apologies to Ron for not reading
his help properly

Nick
 
Top