cell protection
 

I need to protect some cells from user input, but need to changes the values
of these cells via code. How can I do this?

Sheldon

cell protection
 

Hi Sheldon.

Protect the worksheet, setting the UserInterfaceOnly argument to true. This
argument is not persistent, so you could reset it in the Workbook_Open
event.

The UserInterfaceOnly argument will permit code manipulation of the locked
cells on the protected sheet.


---
Regards,
Norman



"Sheldon" wrote in message
...
I need to protect some cells from user input, but need to changes the
values
of these cells via code. How can I do this?

Sheldon