On Jul 1, 6:25*pm, "Per Jessen" wrote:
Hi Per,

Thanks for the input. I have already protected the sheets. My
requirement is that sheets should not be deleted. I am afraid that the
user may delete the worksheets in case the workbook is not protected.
Hence the code for protecting the workbook. But, the issue is why is
the workbook protection not happening despite the code?

Regards,
Raj

Hi Raj

Your code works fine here in excel 2000 & 2007. I closed the workbook
without protection. Once i opened it again. it was protected. If I right
click on a sheet tab the options "Insert", "Delete" etc. is grayed out.

Regards,
Per

Hi Per,

Thanks for the trouble you have taken. Your assertion about the code,
made me think further. I was wrong. I was wrongly assuming that the
icon under "Review" tab in Excel 2007 would change to "Unprotect
Workbook" when the workbook is protected similar to the "Unprotect
Sheet" that happens when a Sheet is protected.

Regards,
Raj