Privacy warning

[TengoKbailar]

Hi,
I have put a macro in my spreadsheet to clear all hyperlinks it works great but now I keep getting the privacy warning message.
I have set the macro settings to accept all and put the spreadsheet in the trusted locations......but the warnings still keep coming
I do not want to turn off all messages just this one.
Thanks
Michael

 

[TengoKbailar]

Hi Oorang,
I did not think to run the code you sent and when I did it returned an error massage
Run-Time error '9'
Subscript out of range

Michael

 

[TengoKbailar]

Hi Vagabond,
I have already set the macro settings to enable all macros & put the spreadsheet in the trust centre.
Thanks
Michael

 

[Oorang]

Hi Oorang,
I did not think to run the code you sent and when I did it returned an error massage
Run-Time error '9'
Subscript out of range
Michael

Hi Michael,
The example I posted needed the index value to be updated the appropriate number. Perhaps this approach will be a bit more intuitive.

Public Sub Example()
    Dim eai As Excel.AddIn
    On Error Resume Next
    For Each eai In Excel.AddIns
        If eai.Name = "Whatever the filename is (name only, not path)." Then
            Exit For
        End If
    Next
    If Not eai Is Nothing Then
        If eai.Installed Then eai.Installed = False
    End If
End Sub

 

[TengoKbailar]

Hi Oorang,
I have pur your code in & excuted it but .......they still keep coming.....
Michael

 

[TengoKbailar]

Hi,
I´m still getting the warning, it seems to be on a timer as it pops up every 14 minutes and then everything hangs....its really annoying
Any more help / solutions much appreciated.
Thanks
Michael

 

[Get VBA or die tryin']

I had this after trying out the Document inspector - every time after that when I saved I got the message you stated. To turn it off in Excel 2007 go to Options > Trust Center > Privacy Options > Document Specific Settings > deselect "Remove personal information from file properties on save"

 

[martijnexcel]

I had a similar problem. Indeed the warning message can be turned off, but it's better to get rid of the reason of it popping up of course.
Since my xlsm did not have any special commands that would influence the privacy i was surprised for getting it as well. The solution seemed quite strange, but it worked for me. I just exported all my modules and copied all the sheets to a new excel file. Then importing the modules again and the problem was solved, no more warnings about privacy etc.
It's probably just a bug, but it's surely an annoying one!

 

[Dora]

I had this after trying out the Document inspector - every time after that when I saved I got the message you stated. To turn it off in Excel 2007 go to Options > Trust Center > Privacy Options > Document Specific Settings > deselect "Remove personal information from file properties on save"

Warning was blocked. thank you.

 

[dmerces]

Hi guys.
Better late than never.

• Click on Excel Options button
• Select Trust Center tab
• Click on Trust Center Settings...
• Select Privacy Options tab
• Uncheck Remove personal information from file properties on save

That's all!