delete a spread sheet

[Mats]

I want to delete spread sheet in a shared workbook. Is it possible?

Mats

 

[Luke M]

Shared workbooks have limits on what you can do to the workbook structure.
You would need to first unshare the workbook before deleting the sheet.

 

[Sean Timmons]

and just to piggyback, You unshare by going to Tools > Share Workbook and
uncheck the share checkbox.

This will cause anyone who is still accessing the file to lose connection
and have only read access to the most recent update they have done.

So, may want to let everyone know if you're about to do this.

 

[Shary]

I have unprotected the workbook, unshared the workbook and Delete Sheet is
still greyed out. What am I doing wrong? This is in Excel 2007 and I saved
it as a xlsm macro enabled workbook.

 

[Sean Timmons]

To verify, have you removed any protect worksheet as well? Also, does the
workbook happen to have a macro, or any VBA code in it? Right-Click on the
tab name and select View Code. Not sure if you'd have any code there locking
the tabs...

If nothing else works, and you have no programming in the background, you
can always move all other sheets to a new workbook and overwrite this one.
May not fix, but it sure does work...