Exporting to Excel and Protecting Cells

[r3g]

hi,

i have an ASP script which loads a crystal report and exports it to an excel sheet - this part works fine. this excel sheet is then emailed to some users. however i'm interested in locking certain cells so that the users cannot edit the fields.

does anyone have a suggestion on how to do this ? i was thinking of opening the xl sheet in my asp code and hard-coding the cell values i needed to lock and then password protecting the whole sheet; although i'm not too keen on that idea.

thanks