Assign Key via VBA?

ptmuldoon · #1 11-30-2014, 05:36 PM

I know how to assign a shortcut key to a macro via the Options Menu in Word. But is it possible to assign the shortcuy key on Word's startup?

Essentially, I am creating a macro that will go in the user's Word Startup folder for all employees in my office. But he/she should not need to assign the macro key shortcut on their own.

Thus, I'm trying to assign a shortcut key and/or a quickaccess menu item to run the when word opens.

I think its possible, i'm just not the strongest with Word and VBA, with google being my main source of help so far (and macropod !)

ptmuldoon · #2 11-30-2014, 07:34 PM

I think i'm close with this, but when I copy the dotm file to the start folder of another pc, its not working. It appears as if the file is not even opening when I start Word, although it is in the correct start folder as well.

Code:

Sub AutoOpen()
     With Application
         ' \\ Do customization in THIS document
         ' .CustomizationContext = ThisDocument
         
         ' \\ Add keybinding to this document Shorcut: Alt+0
        .KeyBindings.Add KeyCode:=BuildKeyCode(wdKeyControl, wdKeyAlt, wdKeyL), _
        KeyCategory:=wdKeyCategoryCommand, _
        Command:="ChangeFileLinks"
    End With

End Sub

gmaxey · #3 11-30-2014, 08:26 PM

Change your macro name to AutoExec

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to assign a labor resource more than once	ketanco	Project	3	02-11-2014 12:23 PM
Assign a value to a Content Control	SuzeG	Word VBA	10	12-08-2013 08:04 AM
Assign Hotkey	Andrew H	Word VBA	3	11-26-2012 09:56 PM
VBA to Assign Aliases	jerem	Word VBA	3	12-08-2011 07:11 PM
Assign functions to F1, etc.	ibclare	Office	4	06-02-2011 03:22 PM