wont allow adding worksheet

E

Ehren

Hello!

We have a excel workbook we use to keep track of inventory and there are
several worsheets inside that hold different sets of data. The problem is
that all of the sudden it will not let us add any more worsheets to the
workbook. There are only 10 worksheets right now so I know its not a 'limit'
thing. I try right clicking the tabs and insert is greyed out and also click
insert menu at the top and 'worksheet' is greyed out. Anyone know of
anything that could be causing this??

Thanks in advance!!
 
B

Bernie Deitrick

Ehren,

Your workbook appears to be protected.

Use Tools / Protection.... Unprotect Workbook and you should be able to insert worksheets.

HTH,
Bernie
MS Excel MVP
 
G

Gord Dibben

Sounds like you have set workbook protection to "on".

Tools>Protection>Unprotect workbook.

You may have to supply a password to unlock if someone has deliberately
protected the book.


Gord Dibben MS Excel MVP
 
E

Ehren

Thank you much!

Gord Dibben said:
Sounds like you have set workbook protection to "on".

Tools>Protection>Unprotect workbook.

You may have to supply a password to unlock if someone has deliberately
protected the book.


Gord Dibben MS Excel MVP
Click to expand...
 
Top