I have 4 spreadsheets, one for each school, each containing 100+
worksheets with the same worksheet names. The only difference between
them is the data (inventory) that is recorded in each. it is time to
roll the totals for next year and add new products. All 4 have been
unprotected and 3 of them will allow the inserting of new worksheets,
but the 4th when I right-click on an adjoining tab is displaying
grayed out 'INSERT, DELETE, RENAME, MOVE or COPY'. I need to insert
new worksheets for new products. Does anyone have any ideas as to why
this one workbook would disallow the insertion of a new worksheet?
None of the workbooks have passwords but all are protected (without a
Thanks in advance.