Macro to insert Current Time into protected cell

[[email protected]]

I'm trying to create a time sheet and I want to have a macro insert the
current time into a protected cell (to stop people editing the time
manually)
Is this possible?? Any tips/hints

[Ron de Bruin]

One way is to unprotect the sheet in the code (password = ron)

ActiveSheet.Unprotect "ron"
Range("C10").Value = Format(Time, "hh mm ss")
ActiveSheet.Protect "ron"



--
Regards Ron de Bruin
http://www.rondebruin.nl


<[email protected]> wrote in message news:[email protected]...
>
> I'm trying to create a time sheet and I want to have a macro insert the
> current time into a protected cell (to stop people editing the time
> manually)
> Is this possible?? Any tips/hints
>