How can I lock a single cell in an Excel following data entry?
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? |
How can I lock a single cell in an Excel following data entry?
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? |
All times are GMT +1. The time now is 04:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com