View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kcdonaldson
 
Posts: n/a
Default How can i use a command button to validate date and time

I have two command buttons, each on a different sheet. i need both of them to
put the current date in one cell on its sheet and current time in another on
its sheet. i also need these cells to be locked so the user can only edit
these cells by clicking the command button. Any answers?