Protect Worksheet Help!

  • Thread starter Thread starter lehainam
  • Start date Start date
L

lehainam

Dear all,

I have a workbook of 5 worksheets and I want to protect only Sheet1 &
Sheet2 that user can not delete or change sheet name. Other sheets user
can do anything they want.

Could anyone can help me.

Thanks a lot!

Nam
 
Protecting a sheet does not protect the sheet name. You have to protect the
workbook if you want to protect the name shown on the TAB at the bottom.
 
Dear Cush,

My question is that user can not delete or change name of sheet1 &
sheet2, the rest can be deleted or changed name and user can add more
sheets.

Thanks,

Nam
 
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 VBA help: Text file formatting 19
Protect a single worksheet? 6
Excel Move or Copy Stopped Working? 0
Different password for different worksheet " Help !" 1
Replace worksheet 1
loop to copy paste 5
VBA code, delete worksheets 4
Embed information in Worksheet for error checking 0

Back
Top