can't delete worksheet--grayed out!

G

Guest

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 tools>protection, the only
option I have is to protect worksheet/workbook. Any help you can offer is
much appreciated! Thanks.
 
D

Debra Dalgleish

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

Guest

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

Guest

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
'Edit>Delete Sheet' command or the pop-up menu 'delete sheet' command?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top