View Single Post
 
Old 06-16-2023, 07:33 AM
leurne leurne is offline Windows 10 Office 2021
Novice
 
Join Date: Jun 2023
Posts: 9
leurne is on a distinguished road
Default 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?
Reply With Quote