Thread: problem with date stamp and protected cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default problem with date stamp and protected cells
Hi,

Just after .Value = Date
add .Locked = True

and do not forget at the end of your code
to add
ActiveSheet.Protect

HTH
Cheers
Carim

Reply With QuoteReply With Quote