Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default Inserting sheets into Excel workbook

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Inserting sheets into Excel workbook

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 180
Default Inserting sheets into Excel workbook

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Inserting sheets into Excel workbook

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Inserting sheets into Excel workbook

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default Inserting sheets into Excel workbook

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Inserting sheets into Excel workbook

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting deleting rows?how do i get the other sheets to do the sa cunningham82 Excel Discussion (Misc queries) 0 December 27th 06 10:51 PM
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? Dmitry Excel Worksheet Functions 6 March 29th 06 01:43 PM
linking sheets and inserting lines debbieevans Excel Discussion (Misc queries) 0 March 16th 06 10:34 AM
Inserting Sheets from multiple files fgwiii Excel Discussion (Misc queries) 2 November 2nd 05 09:47 PM
Updating, Deleting and inserting rows over two Excel Sheets Dilip Mistry Excel Worksheet Functions 0 July 25th 05 08:09 PM


All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"