Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TDiesel216
 
Posts: n/a
Default can't delete worksheet--grayed out!

For some reason, I can't delete worksheets from my workbook. I am able to
insert worksheets and edit worksheets, and it doesn't appear that my
worksheet/workbook is protect. When I go to toolsprotection, the only
option I have is to protect worksheet/workbook. Any help you can offer is
much appreciated! Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default can't delete worksheet--grayed out!

If the workbook is shared you won't be able to delete sheets. To turn
off sharing, choose ToolsShare Workbook.
On the Editing tab, remove the check mark from 'Allow changes by more
than one user at the same time'
Click OK

TDiesel216 wrote:
For some reason, I can't delete worksheets from my workbook. I am able to
insert worksheets and edit worksheets, and it doesn't appear that my
worksheet/workbook is protect. When I go to toolsprotection, the only
option I have is to protect worksheet/workbook. Any help you can offer is
much appreciated! Thanks.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TDiesel216
 
Posts: n/a
Default can't delete worksheet--grayed out!

The workbook is not shared--when I go to 'share workbook', the check mark
does not exist. Any other suggestions?

"Debra Dalgleish" wrote:

If the workbook is shared you won't be able to delete sheets. To turn
off sharing, choose ToolsShare Workbook.
On the Editing tab, remove the check mark from 'Allow changes by more
than one user at the same time'
Click OK

TDiesel216 wrote:
For some reason, I can't delete worksheets from my workbook. I am able to
insert worksheets and edit worksheets, and it doesn't appear that my
worksheet/workbook is protect. When I go to toolsprotection, the only
option I have is to protect worksheet/workbook. Any help you can offer is
much appreciated! Thanks.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TDiesel216
 
Posts: n/a
Default can't delete worksheet--grayed out!

Okay, so I added the 'delete sheet' button onto my toolbar--this allows me to
delete sheets. So, if I am able to do this, which can't I use the
'EditDelete Sheet' command or the pop-up menu 'delete sheet' command?

"TDiesel216" wrote:

The workbook is not shared--when I go to 'share workbook', the check mark
does not exist. Any other suggestions?

"Debra Dalgleish" wrote:

If the workbook is shared you won't be able to delete sheets. To turn
off sharing, choose ToolsShare Workbook.
On the Editing tab, remove the check mark from 'Allow changes by more
than one user at the same time'
Click OK

TDiesel216 wrote:
For some reason, I can't delete worksheets from my workbook. I am able to
insert worksheets and edit worksheets, and it doesn't appear that my
worksheet/workbook is protect. When I go to toolsprotection, the only
option I have is to protect worksheet/workbook. Any help you can offer is
much appreciated! Thanks.



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
delete grayed out in excel Leon Steenkamp Excel Discussion (Misc queries) 1 February 16th 06 03:09 PM
How do you delete a worksheet? Don J Excel Discussion (Misc queries) 5 January 3rd 06 07:11 PM
I can't delete a whole sheet in Excel. Option is grayed out. Tommyboy Excel Worksheet Functions 2 November 29th 05 04:22 PM
One worksheet to calulate different items simultaneously John Excel Worksheet Functions 4 November 28th 05 07:07 PM
how to delete an excel file? how to e-mail a worksheet? mailman New Users to Excel 1 August 25th 05 10:23 AM


All times are GMT +1. The time now is 03:02 PM.

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

About Us

"It's about Microsoft Excel"