[grnadpa]

Good morning,

Can I check for a Excel 2003 cell attribute of "lock" without protecting the sheet?

Also, can I detect the cell that changed versus the current cell?

Because the client wants to use the Excel outline capability, I cannot lock and protect.

Originally I chose to check for a specific background color for modifiable cells through VBA. (Code which I apparently since lost in a prior version).

Even then I had a time trying to detect which cell changed versus the current cell (to undo if the changed cell was "protected").

Thanks

Grnadpa Brian

[grnadpa]

Figured it out

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If target.locked then ...
end sub

And then I simply unlock the relevant column / cells and leave the rest locked (without protecting the sheet.)