Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete a spread sheet
I want to delete spread sheet in a shared workbook. Is it possible?
Mats |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete a spread sheet
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete a spread sheet
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete a spread sheet
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete a spread sheet
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete a spread sheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I Delete data in a spread sheet and keep formulas | Excel Discussion (Misc queries) | |||
how do i enter a bull call spread into the options spread sheet ? | Excel Worksheet Functions | |||
spread sheet | Excel Discussion (Misc queries) | |||
spread sheet | New Users to Excel | |||
How do i delete duplicate rows in an Excel Spread Sheet | Excel Worksheet Functions |