Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Oct 2006
    Location
    Albany, New York, USA
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Stamp (Word 2003 sp-3)

    I’m trying to put a date on a document automatically and have it not update automatically.
    I have tried to use the field DATE @ "M/d/yyyy h:mm:ss am/pm"
    but it updates automatically whenever someone opens the document. This needs to be an automatic date stamp.
    We have macro security set on high so macros are out.

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Date Stamp (Word 2003 sp-3)

    Hi Ed

    F.W.I.W.
    Macros aren't necessarily out as a consequence of security being set to High or Very High. If they are contained in a template that is stored in a trusted location, they will run. Cocuments and Settings [username] Application DataMicrosoftWordSTARTUP is a default trusted location

    H.T.H.
    Regards
    Don

  3. #3
    Star Lounger
    Join Date
    Oct 2006
    Location
    Albany, New York, USA
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Stamp (Word 2003 sp-3)

    Thanks Hans,
    As usual you're right on the nose. This is exactly what my user was looking for. I gave you full credit for the fix
    To turn off the lock however it's Ctrl+Shft+F11 (not F9) probably a mistype.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Stamp (Word 2003 sp-3)

    Yes, that's a typo indeed, sorry about that. I'll correct my previous reply.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Stamp (Word 2003 sp-3)

    You can lock a field against updating by selecting it and pressing Ctrl+F11.
    If you ever want to unlock it, press Ctrl+Shift+F11 (I originally wrote Ctrl+Shift+F9, that was incorrect!)

    But perhaps you can use the CREATEDATE or SAVEDATE field instead of the DATE field. The former is the date the document was originally created, and the second the date the document was last modified and saved.

  6. #6
    Star Lounger
    Join Date
    Oct 2006
    Location
    Albany, New York, USA
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Stamp (Word 2003 sp-3)

    Thaks Don,
    The folks that will be using this document won't be able to do this. Just went through a similar situation with another user. Very frustrating.

  7. #7
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Date Stamp (Word 2003 sp-3)

    Another way to run Macros is to sign the code with a Digital Certificate and instruct the users to Trust this certificate (which they only need to do once).

    StuartR

Posting Permissions

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