Home/ Questions/Q 8135
Next
In Process
Computing Staff
  • 0
Asked: 2021-11-26T12:07:19+00:00 In:

How Do I Launch A Word Macro From A Desktop Shortcut?

  • 0

I created a multi-page form in MS Word 2010. I then drafted a short macro that inserts the date and time into the form and then moves the cursor to the first open field. I want to put a shortcut on my desktop that, when clicked, opens Word, opens the document and runs the short macro. How do I do that?

I was hoping to find the macro file and drag-and-drop a copy onto my desktop so that when I click it it would automatically open the document and run the set-up macro. I found the normal.dotm file but can’t access individual macros within it. Is there a way to place on my desktop a shortcut to a particular Word macro?

Thanks.

Share

    1 Answer

    1. Perhaps this will work for you..

      In the Visual Basic Editor you will see a ThisDocument module for your Word document.

      If you use a Document_Open event macro in that module, the code will run as soon as the document is opened.

      The code below presents a MsgBox whenever the document is opened:

      Private Sub Document_Open()
  MsgBox "I'm Open!"
End Sub

      Perhaps if you replace my instruction with your instructions, you’ll get what you want.

      All you’ll need is a shortcut to the document itself on your desktop.

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      • 0