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

 

[Oorang]

It is difficult to identify problems with code you have not posted

 

[TengoKbailar]

Sorry here is the code

Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

Thanks
Michael

 

[Oorang]

No problem That does not raise a warning for me. What is the exact language of the warning? Also what version of excel are you using?

 

[TengoKbailar]

Hi Oorang,
I´m useing Office 2007
The message is a pop up which says
"Privacy warning:This document contains macros, ActiveX controls, XLM expansion pack information, or web components. These may include personal information that cannot be removed by the Document Inspector"

The only thing I have added is the macro and the message has only apeared since then.
Thought.....could it be because of the hyperlinks? I just copied & pasted them but the message keeps coming after I have run the macro and cleared them

Thanks
Michael

 

[crimson_b1ade]

disable Document Inspector.

 

[Oorang]

Which can be done with:

excel.AddIns.Item(index).Installed=False

If it's for anyone but you, I'd make sure you turn it back on when you are done.

 

[TengoKbailar]

Hi,
Don´t think that has worked.
I installed the code but everytime I click Save......up pops the warning
I´ll see if it keeps poping up during the day.
Thanks
Michael

 

[TengoKbailar]

Just to say the messages are still popping up

 

[Vgabond]

Just to say the messages are still popping up

I don't know whether it's working or not. Try this :-

Click Tools -> Option -> Security - Choose Macro Security and In Security Level , choose Low.