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 toolsgt;protection, the only
option I have is to protect worksheet/workbook. Any help you can offer is
much appreciated! Thanks.
If the workbook is shared you won't be able to delete sheets. To turn
off sharing, choose Toolsgt;Share 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:
gt; For some reason, I can't delete worksheets from my workbook. I am able to
gt; insert worksheets and edit worksheets, and it doesn't appear that my
gt; worksheet/workbook is protect. When I go to toolsgt;protection, the only
gt; option I have is to protect worksheet/workbook. Any help you can offer is
gt; much appreciated! Thanks.The workbook is not shared--when I go to 'share workbook', the check mark
does not exist. Any other suggestions?
quot;Debra Dalgleishquot; wrote:
gt; If the workbook is shared you won't be able to delete sheets. To turn
gt; off sharing, choose Toolsgt;Share Workbook.
gt; On the Editing tab, remove the check mark from 'Allow changes by more
gt; than one user at the same time'
gt; Click OK
gt;
gt; TDiesel216 wrote:
gt; gt; For some reason, I can't delete worksheets from my workbook. I am able to
gt; gt; insert worksheets and edit worksheets, and it doesn't appear that my
gt; gt; worksheet/workbook is protect. When I go to toolsgt;protection, the only
gt; gt; option I have is to protect worksheet/workbook. Any help you can offer is
gt; gt; much appreciated! Thanks.
gt;
gt;
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
'Editgt;Delete Sheet' command or the pop-up menu 'delete sheet' command?
quot;TDiesel216quot; wrote:
gt; The workbook is not shared--when I go to 'share workbook', the check mark
gt; does not exist. Any other suggestions?
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt; gt; If the workbook is shared you won't be able to delete sheets. To turn
gt; gt; off sharing, choose Toolsgt;Share Workbook.
gt; gt; On the Editing tab, remove the check mark from 'Allow changes by more
gt; gt; than one user at the same time'
gt; gt; Click OK
gt; gt;
gt; gt; TDiesel216 wrote:
gt; gt; gt; For some reason, I can't delete worksheets from my workbook. I am able to
gt; gt; gt; insert worksheets and edit worksheets, and it doesn't appear that my
gt; gt; gt; worksheet/workbook is protect. When I go to toolsgt;protection, the only
gt; gt; gt; option I have is to protect worksheet/workbook. Any help you can offer is
gt; gt; gt; much appreciated! Thanks.
gt; gt;
gt; gt;
- Feb 22 Thu 2007 20:35
can't delete worksheet--grayed out!
close
全站熱搜
留言列表
發表留言