Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Macro for file property

    I sometimes receive Word files with the "File > Options > Trust Center > Trust Center Settings > Privacy Options >
    'Remove personal information from file properties on save'" option ticked, and if I leave it ticked, it removes my initials from any comments I insert, so I need to make sure it is unticked before I start inserting comments.

    I tried to record a macro to untick this option via a keyboard shortcut ("File > Options > Trust Center > Trust Center Settings > Privacy Options >
    untick 'Remove personal information from file properties on save'"), but the recorded macro was empty some reason. Is there a way to create a macro to do this?
    Last edited by Murgatroyd; 2015-09-28 at 01:10.

  2. #2
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,048
    Thanks
    124
    Thanked 119 Times in 116 Posts
    Code:
    Sub AllowInitials()
    
        ActiveDocument.RemovePersonalInformation = False
    End Sub
    Charles Kyle Kenyon
    Madison, Wisconsin

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts
    That works fine, thanks. (Why couldn't I get the macro recorder to create this?)

  4. #4
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,048
    Thanks
    124
    Thanked 119 Times in 116 Posts
    There are a lot of Word features that the macro recorder will not pick up.
    See How to Modify a Recorded Macro and Getting to Grips with vba Basics in 15 Minutes.

    This took less than 10 minutes to write. The hard part was finding the property name. I used Google for that.
    Charles Kyle Kenyon
    Madison, Wisconsin

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts
    OK thanks.

Posting Permissions

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