Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: How do I turn of those annoying security messages?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    have you tried using Application.DisplayAlerts = false

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Are the alerts coming from excel or Norton?

    Regards,

    Gary Hewitt-Long

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Still not solved

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    keeping this on top cos i really need an answer!

  9. #9
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!!!

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.



    Regards,

    Gary Hewitt-Long

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •