Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete sheet in shared workbook
Hi All
I have workbook with one worksheet (ex. "MySheet"). I have macro to insert template sheet, collect data from another workbook,copy to template sheet, to sort data in template sheet and then put correct data in to the My Sheet and then I like to delete template sheet. That is my problem, macro cant delete template sheet. Is there a way delete sheet in shared workbook? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete sheet in shared workbook
How did you insert a worksheet into that shared workbook?
Jaan wrote: Hi All I have workbook with one worksheet (ex. "MySheet"). I have macro to insert template sheet, collect data from another workbook,copy to template sheet, to sort data in template sheet and then put correct data in to the My Sheet and then I like to delete template sheet. That is my problem, macro cant delete template sheet. Is there a way delete sheet in shared workbook? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete sheet in shared workbook
I never used shared workbooks so can't answer your question directly.
But if you can't delete the template sheet because the book is shared, why don't you just create the template in the source data workbook, do the sort there, then copy the sorted data to MySheet? I suppose you could also clear and hide the template sheet in the shared workbook if it's no big deal that it's there. SteveM On Oct 23, 3:26 am, Jaan wrote: Hi All I have workbook with one worksheet (ex. "MySheet"). I have macro to insert template sheet, collect data from another workbook,copy to template sheet, to sort data in template sheet and then put correct data in to the My Sheet and then I like to delete template sheet. That is my problem, macro cant delete template sheet. Is there a way delete sheet in shared workbook? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete sheet in shared workbook
Hi Dave
I insert it with my macro Sheets.Add.Name ="Problems". I like answer from Steve, but nevertheless I like to know how I can delete it. "Dave Peterson" kirjutas: How did you insert a worksheet into that shared workbook? Jaan wrote: Hi All I have workbook with one worksheet (ex. "MySheet"). I have macro to insert template sheet, collect data from another workbook,copy to template sheet, to sort data in template sheet and then put correct data in to the My Sheet and then I like to delete template sheet. That is my problem, macro cant delete template sheet. Is there a way delete sheet in shared workbook? -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete sheet in shared workbook
Thank you Steve
The simplicity is the brilliance Why I didn't know it myself.The sheet hiding can solve my problem, but nevertheless I like to know, how delete it "SteveM" kirjutas: I never used shared workbooks so can't answer your question directly. But if you can't delete the template sheet because the book is shared, why don't you just create the template in the source data workbook, do the sort there, then copy the sorted data to MySheet? I suppose you could also clear and hide the template sheet in the shared workbook if it's no big deal that it's there. SteveM On Oct 23, 3:26 am, Jaan wrote: Hi All I have workbook with one worksheet (ex. "MySheet"). I have macro to insert template sheet, collect data from another workbook,copy to template sheet, to sort data in template sheet and then put correct data in to the My Sheet and then I like to delete template sheet. That is my problem, macro cant delete template sheet. Is there a way delete sheet in shared workbook? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete sheet in shared workbook
Look at "features unavailable in a shared workbook" in Excel's help and you'll
see that deleting sheets is one of those unavailable features. Jaan wrote: Hi Dave I insert it with my macro Sheets.Add.Name ="Problems". I like answer from Steve, but nevertheless I like to know how I can delete it. "Dave Peterson" kirjutas: How did you insert a worksheet into that shared workbook? Jaan wrote: Hi All I have workbook with one worksheet (ex. "MySheet"). I have macro to insert template sheet, collect data from another workbook,copy to template sheet, to sort data in template sheet and then put correct data in to the My Sheet and then I like to delete template sheet. That is my problem, macro cant delete template sheet. Is there a way delete sheet in shared workbook? -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete sheet in shared workbook
Dave
Thank you for response "Dave Peterson" kirjutas: Look at "features unavailable in a shared workbook" in Excel's help and you'll see that deleting sheets is one of those unavailable features. Jaan wrote: Hi Dave I insert it with my macro Sheets.Add.Name ="Problems". I like answer from Steve, but nevertheless I like to know how I can delete it. "Dave Peterson" kirjutas: How did you insert a worksheet into that shared workbook? Jaan wrote: Hi All I have workbook with one worksheet (ex. "MySheet"). I have macro to insert template sheet, collect data from another workbook,copy to template sheet, to sort data in template sheet and then put correct data in to the My Sheet and then I like to delete template sheet. That is my problem, macro cant delete template sheet. Is there a way delete sheet in shared workbook? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Individual sheet protection in shared workbook | Excel Worksheet Functions | |||
How to create & delete sheets in a shared Excel workbook? | Excel Worksheet Functions | |||
Display a update date on a sheet for a shared excel workbook | Excel Worksheet Functions | |||
EnableOutlining with shared workbook protected sheet? | Excel Programming | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions |