I would like to create a macro (or add a button to the toolbar) that will
insert todays date and time into a selected cell. (word does this nicely and
gives the option to automatically update or to remain static- - I need static
dates with an easy way for multiple users to insert them ) The =TODAY
function will insert the date but not the time and the =NOW function updates
all cells with "now" dates to the most recently inserted. The date and time
will be used to track info in adjacent cells. The date needs to remain static
so that users can see dates and times that the info was added.
new to macros/ keep it simple
THANKS!