View original (French)

Macro activation error

Solved
vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   -  
vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   -

Hello,

I am currently creating an Excel file with a macro. Since the beginning, I was able to get my file to work during my tests.
Then, for no reason, I find myself with an error and my macros no longer work. The PC blocks me even though everything was functioning until now.

Here is a screenshot:

Thank you


8 answers

  1.
    NonoM45 Posted messages 1044 Registration date   Status Member Last intervention   5
     

    Hello,

    The message is clear to me, your system administrator must have changed the GPO (Group Policy Object), check with him!

    See you!

    0
    1. vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
       

      I am the administrator of the PC, I haven't blocked anything at all. Suddenly it shows me this without having done anything.

      Thank you

      0
  2. brucine Posted messages 25260 Registration date   Status Member Last intervention   4 187
     

    Hello,

    We cannot know for this particular file without having it.

    Generally speaking, Excel cries that macros or the origin of the files are not allowed in Options-Trust Center-Settings which you should adapt accordingly.

    0
    1. vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
       

      I haven't changed any parameters, and all of a sudden I got this message.

      Thank you

      0
  3. danielc0 Posted messages 2223 Registration date   Status Member Last intervention   296
     

    Hello,

    Click on File, Options, Trust Center, Trust Center Settings, Approved Documents. Click on the "Clear all approved documents" button so that they are no longer approved.

    Without warranty...

    Daniel

    0
    1. vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
       

      I just did it but it's still the same

      0
  4. danielc0 Posted messages 2223 Registration date   Status Member Last intervention   296
     

    Do you have the same problem with another workbook containing macros?

    Daniel

    0
    1. vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
       

      With the other files, it works very well.

      0
  6. danielc0 Posted messages 2223 Registration date   Status Member Last intervention   296
     

    PS. Do you receive the same message when the workbook is no longer approved?

    0
    1. vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
       

      Yes, he asked me again to activate the content, and once activated, he gives me the same message.

      0
      1. danielc0 Posted messages 2223 Registration date   Status Member Last intervention   296 > vcloclo1 Posted messages 493 Registration date   Status Member Last intervention  
         

        Start over but do not approve the workbook to see. Also, look into the history of Excel 4 macros as cousinhub29 asked you.

        Daniel

        0
      2. vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33 > danielc0 Posted messages 2223 Registration date   Status Member Last intervention  
         

        No xl4 macros

        0
  7. cousinhub29 Posted messages 1166 Registration date   Status Member Last intervention   415
     

    Hello thread,

    Has there been an update to Office without your knowledge?

    Do you use xl4 macros in your code, or in a named formula?

    0
    1. vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
       

      No xl4 macros

      0
  8. cousinhub29 Posted messages 1166 Registration date   Status Member Last intervention   415
     

    Hello,

    Could you upload your file, with no data but all the codes? (I specify, the original file, from which you remove all the data, but you keep all the tabs and the codes)

    You can post it on cjoint.com, and put the link here

    0
  9. vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
     

    Issue resolved, I checked the boxes "Enable Excel 4.0 macros when VBA macros are enabled" and also "Trusted access to the VBA project object model"

    Now everything is working again.

    0