How do I turn of those annoying security messages?

Thespiv · Mar 3rd, 2002, 05:12 PM

I have a database with hyperlinks to Audio files (MP3's),I have tried following the Excel Help guidence, but still get the "Some files contain viruses message", I am running Norton Antivirus Software as well. I want to be able to click on my buttons and have the file play instantly without the warnings, can this be done?

Paul B · Mar 3rd, 2002, 08:35 PM

have you tried using Application.DisplayAlerts = false

gplhl · Mar 3rd, 2002, 10:34 PM

Are the alerts coming from excel or Norton?

Thespiv · Mar 4th, 2002, 03:56 AM

Sorry Paul, a lille Green Around Script, any chance you could show me the syntax and possitioning of the command you suggest?
oh the messages are Office driven rather than Norton.

Thespiv · Mar 4th, 2002, 04:23 AM

IT gets worse, I pasted Paul's code in to my Visual Basic and I Get this message: You vave modified a signed project you do not have the right key to sign this project, the signature will be discarded, I saved, closed, re-opened and still get the same security message

Thespiv · Mar 4th, 2002, 07:20 AM

Still not solved

Thespiv · Mar 4th, 2002, 10:36 AM

bringing it back to the top in the hope that someone wiil be kind enough to solve this problem

[ This Message was edited by: Thespiv on 2002-03-04 10:20 ]

Thespiv · Mar 4th, 2002, 11:36 AM

keeping this on top cos i really need an answer!

moex201 · Mar 4th, 2002, 11:55 AM

If you are talking about the macro security turned on in Excel 2000 that prompts you when you want to run a macro, the way I turned it off was by clicking on Tools->Macro->Security, and selecting the Low Security option. Make sure you read the warning on this!!!

gplhl · Mar 4th, 2002, 12:14 PM

Quote:

On 2002-03-04 03:23, Thespiv wrote:
IT gets worse, I pasted Paul's code in to my Visual Basic and I Get this message: You vave modified a signed project you do not have the right key to sign this project, the signature will be discarded, I saved, closed, re-opened and still get the same security message

All that is, is that someone else who wrote the project signed it with a digital signature. The digital signature won't be there now.

Signatures can be used for security and to validate that a project has come from a certain location. You can then set individual computers to accept and run macros from these sources without first giving warnings.

Mar 3rd, 2002, 10:34 PM	#3
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	Are the alerts coming from excel or Norton? __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 05:12 PM	#1
Thespiv New Member Join Date: Mar 2002 Posts: 31	I have a database with hyperlinks to Audio files (MP3's),I have tried following the Excel Help guidence, but still get the "Some files contain viruses message", I am running Norton Antivirus Software as well. I want to be able to click on my buttons and have the file play instantly without the warnings, can this be done?

Mar 3rd, 2002, 08:35 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	have you tried using Application.DisplayAlerts = false

Mar 4th, 2002, 03:56 AM	#4
Thespiv New Member Join Date: Mar 2002 Posts: 31	Sorry Paul, a lille Green Around Script, any chance you could show me the syntax and possitioning of the command you suggest? oh the messages are Office driven rather than Norton.

Mar 4th, 2002, 04:23 AM	#5
Thespiv New Member Join Date: Mar 2002 Posts: 31	IT gets worse, I pasted Paul's code in to my Visual Basic and I Get this message: You vave modified a signed project you do not have the right key to sign this project, the signature will be discarded, I saved, closed, re-opened and still get the same security message

Mar 4th, 2002, 07:20 AM	#6
Thespiv New Member Join Date: Mar 2002 Posts: 31	Still not solved

Mar 4th, 2002, 10:36 AM	#7
Thespiv New Member Join Date: Mar 2002 Posts: 31	bringing it back to the top in the hope that someone wiil be kind enough to solve this problem [ This Message was edited by: Thespiv on 2002-03-04 10:20 ]

Mar 4th, 2002, 11:36 AM	#8
Thespiv New Member Join Date: Mar 2002 Posts: 31	keeping this on top cos i really need an answer!

Mar 4th, 2002, 11:55 AM	#9
moex201 New Member Join Date: Mar 2002 Posts: 6	If you are talking about the macro security turned on in Excel 2000 that prompts you when you want to run a macro, the way I turned it off was by clicking on Tools->Macro->Security, and selecting the Low Security option. Make sure you read the warning on this!!!