View Single Post
  #3   Report Post  
D ][\/][ C
 
Posts: n/a
Default


abe Wrote:
We have a worksheet that we want users to be able to press a button on
the
worksheet & which in the next cell near the button, it would stamp the
current time and/or date from the system. Then the cell with the date
and/or
time would be unable to be changed once the button is pressed (locked)


You can shopw the current date and time with a macro assigned to a
button to do what you intend.

Firstly select the cell you intend using and set the date format you
want to use. Then as you start recording your macro with the cell
still selected press(CTRL+; then SPACE then CTRL+SHIFT+; ) to set the
systems current date & time, press stop on the recording toolbar. Now
select the button you intend to use from the (View,Toolbars, Forms)
menu. A list including the macro you just created will appear, assign
this macro to the button. Change the text of the button to whatever the
user will understand


--
D ][\/][ C