Macro to insert Current Time into protected cell
 

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

Macro to insert Current Time into protected cell
 

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


wrote in message oups.com...

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