I am using Excel 97.

The reason I am asking this question is because I have a Worksheet
that has code in the Worksheet_Change(). Each time the user changes
data in this worksheet the code does stuff to validate the data. A lot
of stuff. So I wrote code to do the checking. The problem is if the
user deletes the Worksheet my code is also deleted. If they rename the
sheet, my code stops working.

I tried to protect a an Excel Spreadsheet. I used Tools menu
Protection Protect Workbook. Then I picked protect structure.

Protecting the structure was not good because it protects everything.
I just want to protect the sheet with my code. The user can do
whatever they want to all the other worksheets.

Is there a way to do this.