Consulting

Results 1 to 4 of 4

Thread: Word 2007 datestamp Macro opens Outlook 2007 setup

  1. #1
    VBAX Newbie
    Joined
    Oct 2017
    Posts
    2
    Location

    Word 2007 datestamp Macro opens Outlook 2007 setup

    I have a word 2007 document which has 2 macros in it. The first is to go to the end of the document on open
    Selection.Endkey Unit:=wdstory
    The second is
    Sub dttimestmp()
    '
    ' dttimestmp Macro
    '
    '
        Selection.TypeParagraph
    With Selection.Font
        .Name = "Calibri(Body)"
        .Bold = True
        .Size = "12"
        End With
    Selection.InsertDateTime DateTimeFormat:="ddd MMMM dd, yyyy H:mm", InsertAsField:=False
    With Selection
        .Font.Bold = False
        .Font.Size = "10"
        End With
        Selection.TypeParagraph
    
    End Sub
    which just enters a datestamp and sets formatting etc...

    The problem I'm having in Word 2007 is that when I use the keyboard shortcut CTRL+Shift+A to run the macro Word 2007 automatically starts trying to set up Outlook 2007.

    Any ideas why this should be?

    And if so, how can I stop it?

  2. #2
    VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,709
    Location
    Ctrl+Shift+A opens two macros?

    Open the Macro dialog and look at the Options for each macro.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Newbie
    Joined
    Oct 2017
    Posts
    2
    Location
    It doesn't open two macros. If I run the keyboard shortcut for my macro (CTRL+Shft+A) it tries to run the Outlook 2007 setup . When I cancel the Outlook 2007 setup the macro runs as normal.

    Also, I noticed that when I tried to open visual basic to paste the code into this post that the action of opening visual basic also set off the Outlook 2007 setup procedure

  4. #4
    VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,273
    Location
    Evidently, there's something wrong with your Office installation. Try repairing the Office installation (via Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change > Repair).

    Unless the 'Reset All' option is greyed-out (because you don't have any custom shortcuts), you can also restore the keyboard shortcuts to their original settings by clicking 'Reset All' at the bottom of the Customize Keyboard dialog box. See under File|Options|Customize Ribbon>Keyboard Shortcuts:Customize.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •