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