Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have created a workbook with 7 worksheets. I want to add more worksheets
but the option to Insert Worksheets is grayed out. What have I done to remove this option from just this workbook? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Under Tools go to options then click the Edit tab and make sure that the
"Show Insert Options Buttons" is checked. "Sally" wrote in message ... I have created a workbook with 7 worksheets. I want to add more worksheets but the option to Insert Worksheets is grayed out. What have I done to remove this option from just this workbook? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Make sure you don't have any of the sheets grouped
"מיכאל (מיקי) אבידן" wrote: Maybe: 'Tools' 'Protection' Remove WorkBook Protection'/ Micky "Sally" wrote: I have created a workbook with 7 worksheets. I want to add more worksheets but the option to Insert Worksheets is grayed out. What have I done to remove this option from just this workbook? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would suspect you have the workbook protected.
ToolsProtectionUnprotect workbook. In 2007 ReviewUnprotect workbook. Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 10:24:03 -0800, Sally wrote: I have created a workbook with 7 worksheets. I want to add more worksheets but the option to Insert Worksheets is grayed out. What have I done to remove this option from just this workbook? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can still insert sheet in group mode.
You will insert as many new sheets as you have grouped. Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 11:00:16 -0800, Donna wrote: Make sure you don't have any of the sheets grouped "????? (????) ?????" wrote: Maybe: 'Tools' 'Protection' Remove WorkBook Protection'/ Micky "Sally" wrote: I have created a workbook with 7 worksheets. I want to add more worksheets but the option to Insert Worksheets is grayed out. What have I done to remove this option from just this workbook? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you for the suggestions.
The workbook & worksheets are not protected. The Show Insert Option button is checked. The Allow editing in cell is checked. The Show sheets tab is checked. Under Format - Visibility Unhide sheet is grayed out. Any other suggestions? Thank you. Sally "Sally" wrote: I have created a workbook with 7 worksheets. I want to add more worksheets but the option to Insert Worksheets is grayed out. What have I done to remove this option from just this workbook? |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
By workbook protection I don't mean password to open protection.
I mean ReviewProtect Workbook. Is that what you looked at? Other than that I have no help. If workbook is Shared you can Insert a sheet but not delete it. Gord On Thu, 28 Jan 2010 09:17:01 -0800, Sally wrote: Thank you for the suggestions. The workbook & worksheets are not protected. The Show Insert Option button is checked. The Allow editing in cell is checked. The Show sheets tab is checked. Under Format - Visibility Unhide sheet is grayed out. Any other suggestions? Thank you. Sally "Sally" wrote: I have created a workbook with 7 worksheets. I want to add more worksheets but the option to Insert Worksheets is grayed out. What have I done to remove this option from just this workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
linking sheets and inserting lines | Excel Discussion (Misc queries) | |||
Inserting Sheets from multiple files | Excel Discussion (Misc queries) | |||
Updating, Deleting and inserting rows over two Excel Sheets | Excel Worksheet Functions |