Exporting to Excel and Locking 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.

oh yeah, i'm using cr8.5

thanks

 

[synapsevampire]

I think that you're on the right track there.

You might also have another spreadsheet with the appropriate code (vba) built in, and then when the export happens, execute the other spreadsheet, which automatically imports the data from the export, thereby providing better formatting and security options.

-k