Module updating of Protected Cells
 

Is it possible to have a cell updated using a VBA module while the cell is
protected? I have a module that inputs the date/time in a field when a user
inputs information into another field. I want to protect the date/time so
that the user can not alter it. I am using Excel 2003.

Thanks for the help.

Hi

no, you'll need to unprotect the sheet, undate the cell and then re-protect
the sheet - this can all be done in code
e.g.

activesheet.unprotect "pwd"
'your code here
activesheet.protect "pwd"

use your password instead of pwd or delete if not required

Cheers
JulieD

"GaryByrd" wrote in message
...
Is it possible to have a cell updated using a VBA module while the cell is
protected? I have a module that inputs the date/time in a field when a
user
inputs information into another field. I want to protect the date/time so
that the user can not alter it. I am using Excel 2003.

Thanks for the help.