Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Inserting a new Worksheet

i have an Excel file which already has about 7 worksheets, and i want to add
another one and the 'insert worksheet' option is grayed out and i don't know
why. how can i fix this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Inserting a new Worksheet

Some Protection set?

cRooKsy09 wrote:

i have an Excel file which already has about 7 worksheets, and i want to add
another one and the 'insert worksheet' option is grayed out and i don't know
why. how can i fix this?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Inserting a new Worksheet

Could be the Workbook...........not Worksheet......... is protected under
ToolsProtection.


Gord Dibben MS Excel MVP

On Wed, 6 Jun 2007 08:16:01 -0700, cRooKsy09
wrote:

i have an Excel file which already has about 7 worksheets, and i want to add
another one and the 'insert worksheet' option is grayed out and i don't know
why. how can i fix this?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Inserting a new Worksheet

Look at the workbook protection options. Also look at whether the file is
read-only.
--
David Biddulph

"cRooKsy09" wrote in message
...
i have an Excel file which already has about 7 worksheets, and i want to
add
another one and the 'insert worksheet' option is grayed out and i don't
know
why. how can i fix this?



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 New Worksheet Problems with formula within worksheet Excel Discussion (Misc queries) 0 November 30th 06 04:38 PM
Inserting New Worksheet tim m Excel Discussion (Misc queries) 0 November 29th 06 04:58 PM
Inserting New Worksheet Problems with formula within worksheet Excel Discussion (Misc queries) 0 November 29th 06 04:47 PM
Inserting row in 1 worksheet and updating a different row in another worksheet [email protected] Excel Discussion (Misc queries) 0 August 9th 06 09:13 PM
Problem inserting a new worksheet Nick Excel Discussion (Misc queries) 4 November 17th 05 07:29 AM


All times are GMT +1. The time now is 03:07 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"