On Oct 26, 7:20 am, atledreier wrote:
I have code that create a new worksheet for exporting to a 3rd party
application. The workbook is shared and protected. The temporary
worksheet is created, data is entered (by my code), saved and then
needs to be closed. This works fine as long as the workbook is not
shared and protected. When I share it I get an error telling me I
cannot delete a protected sheet. I've tried
activesheet.unprotect("pwd") with no result. This is Excel97.

Any tips?

Hi
You need to unprotect the workbook, not the sheet, as it is part of
the workbook you are trying to change. You unprotect the sheet if you
want to change it's contents.

With Activeworkbook
.Unprotect password:="pwd"
.worksheets("mysheet").delete
end With

regards
Paul