The worksheet option under "insert" is gray (unavailable)- why?

G

Guest

I want to insert an additional worksheet and the worksheet option under
"insert" is gray. How can I get access to it in order to add a worksheet?
 
G

Gord Dibben

You must remove protection from the workbook.

Tools>Protection>UnProtect Workbook

You may have to supply a password.


Gord Dibben MS Excel MVP


On Wed, 23 Aug 2006 15:36:02 -0700, Spreadsheet issues <Spreadsheet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I add NOT insert additional worksheet to existing workbook. 6
sort 2
How To Stop Chart Sizing With Cells? 2
Formula, Macro, or VBA code to find and insert 3
How to program excel to insert / delete any worksheet? 1
how to automatically update a second worksheet when data inserted 2
disable Insert Worksheet 2
How to code to insert / delete any worksheet? 1

Top