worksheet protection

M

masterflasher

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
 
T

Tom Ogilvy

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.
 
Top