worksheet protection

  • Thread starter Thread starter masterflasher
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Protect a single worksheet? 6
Enable Spelling Check 4
Excel Move or Copy Stopped Working? 0
Protection Macro 2
Password protect select sheets in a workbook 6
Protect individual worksheets from deletion 3
Copying in sheet with protection with the use of a macro 5

Back
Top