I need to write an Excel program with secure data acquisition and need to
lock each cell following entry. Is there an easy way to do this other than
unprotecting the spreadsheet each time and identifying the new cell set to be
locked?

To the best of my knowledge, the sheet has to be unprotected at the time you
change the locked property. That said, it is trivial in code to add the
unprotect and protect commands before and after you change the locked
property of the cell.

--
Regards,
Tom Ogilvy

"JimI" wrote in message
...
I need to write an Excel program with secure data acquisition and need to
lock each cell following entry. Is there an easy way to do this other
than
unprotecting the spreadsheet each time and identifying the new cell set to
be
locked?