bookmark with bookchange
hello, i have a bookmark called DatePP
i would like to make a macro in order to update manually with the current date.
(i dont want to have a automatic date because we can't have some tracking of the update...)
so i wrote:
Sub ladate()
Dim date1 As Date
date1 = Now()
BookChange "DatePP, format(date1, "dd/mm/yy")
End Sub
it's working however if i want to update a second time my date.... The bookmark DatePP disappear...
Do you have an idea how to solve it?
|