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

Mats

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mats" wrote:

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

Mats

Hi,
you mean a sheet in a workbook, position on the sheet, right click on the
mouse, delete

If you didn't create the workbook and the workbook is protected you will not
be able to delete it

if this helps please click yes thanks

"Mats" wrote:

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

Mats

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.

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mats" wrote:

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

Mats

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.
--
Shary


"Sean Timmons" wrote:

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.

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mats" wrote:

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

Mats

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...



"Shary" wrote:

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.
--
Shary


"Sean Timmons" wrote:

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.

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mats" wrote:

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

Mats