clear contents cells of unprotected cells
Thanks, that did it!
"Tom Ogilvy" wrote:
for each cell in activesheet.UsedRange
if cell.locked = false then
cell.Clearcontents
end if
Next
--
Regards,
Tom Ogilvy
"Ed" wrote in message
...
Hi. I am trying to clear the contents of all unprotected cells only on a
protected worksheet. Any ideas how to do it without giving the absolute
cell
reference for each of the unprotected cells I want to clear?
|