Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    416
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word Code Cleaner (Word 2003 - SP3)

    Hi

    I downloaded the code cleaner from the MVP site (as indicated in one of the forum posts). Unfortunately, it doesn't allow me to run it. I have even tried running it on my local machine at home (my macro security is set to LOW) and I get the same result. Any ideas anyone? How can I fix this please? Thanks.

    The error I get is: "Programmatic access to Visual Basic Program is not trusted (CodeCleanerMain)"
    Thanks.
    Robie

  2. #2
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    London, Gtr London, England
    Posts
    416
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Code Cleaner (Word 2003 - SP3)

    You are gem. Hats off to you maestro.
    Thanks.
    Robie

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Word Code Cleaner (Word 2003 - SP3)

    Tools > Options... > Security > Macro Security... > Trusted Publishers > Trust access to Visual Basic Project

    StuartR
    Attached Images Attached Images
    • File Type: gif x.gif (49.8 KB, 0 views)

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Word Code Cleaner (Word 2003 - SP3)

    I strongly recommend clearing the check box again after running the macro that requires it. This setting protects you from all sorts of macro nastiness.

    StuartR

Posting Permissions

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