Microsoft Office Forums - View Single Post - [Solved] Macro / VBA to run at document startup

Thread: [Solved] Macro / VBA to run at document startup

View Single Post

Old

09-22-2019, 04:27 AM

eduzs

eduzs is offline

eduzs uses Windows 10

Windows 10 eduzs uses Office 2010 32bit

eduzs uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2017

Posts: 266

eduzs is on a distinguished road

Default

Simply remove from Sub DATEPLUS7

Quote:

Selection.TypeText Text:=Format(Date + 7, "mmmm d, yyyy")

Quote:

Private Sub Document_Open()
If MsgBox("Run Macro?", vbYesNo, "Message") = vbYes Then Call DATEPLUS7
End Sub

__________________
Backup your original file before doing any modification.

Reply With Quote