Delete sheets and create a new workbook in Shared Workbook.

Hi All,

I wrote a code in unshared workbook and it works fine. But when i make it shared i get Run-time error '1004' Delete method of worksheet class failed.

The Deleting of worksheet only occurs once (when the new wb is created) so is there i can unshare and share it back when the process is complete?

Please Login or Register  to view this content.

So if i were to leave the source WB as unshared, and then share it when new WB is created, do i need to just turn on sharing when the newWBK is saved? i put the following code in but getting error again
new code

Please Login or Register  to view this content.

replaced

Please Login or Register  to view this content.

Compile error: Named argument not found

i think im getting close. It is doing everything i ask for with the below code, however since the WB is already created it asks me to copy over the exisiting file. Is there anyway to just save without the prompt? i inserted the following code, but its asking to copy over the exisitng file.

Please Login or Register  to view this content.

stupid oversight on my part. ive solved it

Please Login or Register  to view this content.