Thread: Macro to insert Current Time into protected cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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



Reply With QuoteReply With Quote