I have an excel 2000 spreadsheet which is locked (worksheet protected using a password). For cells requiring direct user input, the cell's 'locked' property is unticked. However, if text is copied from a Word document into one of these unlocked cells, this property is then set to 'locked', even though the worksheet is protected (and 'format cells' is greyed out). This means the user cannot change or delete the info they've just pasted!
How can I prevent this change to the 'locked' property?
Thanks in advance!
answer seems to be to disable Paste, and redirect ^v to paste special the value
![]()
Bookmarks