Microsoft Office Excel, Privacy warning

[ABabeNChrist]

Something unusual occurred, at least for me it was. I have a workbook xlsx that I have been using to keep records of clients info. After using for over a year without a single problem I then added a piece of code so that when I put a new entry in it would insert current date I then save as xlsm.

Code: Select all

    If Target.Cells.Count > 1 Then Exit Sub
    If Not Intersect(Target, Range("A2:A1000")) Is Nothing Then
        With Target(1, 2)
            .Value = Now
        End With
    End If

From that point on I started to receive this error message.

Privacy Warning.JPG

I search around my excel options trying to look for possibilities, I then uncovered from my Trust Center / Trust Center Settings / Privacy Options / Document-specific settings, that Remove personal information from the file properties on save was checked.

Privacy Option.JPG

I then proceeded to see if any other workbooks had this same check, they did not. Any ideas why this may have been checked. I did uncheck the box and of course the message is gone. Should I be concerned?
Also this workbook will not be shared

[HansV]

Did you get the workbook from the internet? Many people posting Office documents in discussion forums such as this one will tick that check box before uploading.

[ABabeNChrist]

No I set up this workbook from scratch.