ExcelBanter - Write data to a cell, then make it undeletable/selectable

In the Workbook_Open event handler for the workbook, put your code to lock
the date cell. Select the entire worksheet, unlock all other cells, then
select the cell that contains the date and lock that cell. Then protect the
worksheet with a password. This will allow your users to enter data in the
rest of the cells. However, they won't be able to delete rows or columns or
maybe do a lot of other things that they might think that they should be
allowed to do. Make sure to test and understand these other limitations.

If your users are sophisticated enough, however, they could add a new, blank
worksheet to the workbook, copy all of the data and formats to the new
worksheet, and then delete the original worksheet, leaving them with an
unprotected copy of the worksheet that contains the date that you want
locked. They could then change the date, if they wanted to.
--
Regards,
Bill

"Christy " wrote in message
...
Is my idea possible?

I have a template that I write the date to when it's opened.
Then I will save it as a regular file.

As soon as the date is placed into the cell, or when the the
file is reopened again, I do not want any user to be
able to select, delete, or otherwise modify the date in the
cell.

Any ideas how I might be able to handle something like that?

TIA!

Christy

---
Message posted from http://www.ExcelForum.com/