Hi,

I have a workbook with several worksheet.
All I want is to have 2 worksheets to be protected against deletion.
But when I take the option protect worksheet, I only can protec
everything in it but not the deletion of the worksheet.
And if I take the option protect workbook, then ALL my woorksheet ar
protected and I don't want that because my macro will create worksheet
that may be deleted.

Can someone give a solution for my problem please

--
Message posted from http://www.ExcelForum.com

Protecting the workbook is the only protection that protects sheets from
deletion. And it doesn't not let you selectively determine which sheets are
to be protected.

--
Regards,
Tom Ogilvy


"masterflasher " wrote in
message ...
Hi,

I have a workbook with several worksheet.
All I want is to have 2 worksheets to be protected against deletion.
But when I take the option protect worksheet, I only can protect
everything in it but not the deletion of the worksheet.
And if I take the option protect workbook, then ALL my woorksheet are
protected and I don't want that because my macro will create worksheets
that may be deleted.

Can someone give a solution for my problem please?


---
Message posted from http://www.ExcelForum.com/