"Be careful! Parts of your document may include personal information that cannot be removed by the document inspector"

scotthannaford1973

New Member
Joined
Sep 27, 2017
Messages
40
Hi all

I am building a new spread sheet and have included some code that when a cell changes, it puts the date and time of change in another cell - the code is below, used it before and it works as well as always. Unfortunately I have a new laptop and when I save the file, which now has the coding in, it always gives me the annoying message:

"Be careful! Parts of your document may include personal information that cannot be removed by the document inspector"

Saves okay, but how do I stop this coming up? even if I remove the code and save it, same bleddy message!

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo TheEnd
Dim r As Long: r = Target.Row
If r < 2 Then Exit Sub 'rules apply to row 3 onwards
If Not Intersect(Range("Q:R "), Target) Is Nothing Then
Application.EnableEvents = False
Range("R" & r) = Date & " - " & Time
End If
TheEnd:
Application.EnableEvents = True
End Sub
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,113
Office Version
365, 2010
Platform
Windows, Mobile
In Excel Options|Trust Center|Privacy Options try unchecking 'Remove personal information from file properties on save'.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,194
Messages
5,412,980
Members
403,459
Latest member
acharnp

This Week's Hot Topics

Top