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

Answer 1 / 8
NonoM45 Posted messages 1018 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
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
Answer 2 / 8
brucine Posted messages 24668 Registration date   Status Member Last intervention   4 143
 

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
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
Answer 3 / 8
danielc0 Posted messages 2173 Registration date   Status Member Last intervention   285
 

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
vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
 

I just did it but it's still the same

0
Answer 4 / 8
danielc0 Posted messages 2173 Registration date   Status Member Last intervention   285
 

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

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

With the other files, it works very well.

0
Answer 5 / 8
danielc0 Posted messages 2173 Registration date   Status Member Last intervention   285
 

PS. Do you receive the same message when the workbook is no longer approved?
0
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
danielc0 Posted messages 2173 Registration date   Status Member Last intervention   285 > 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
vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33 > danielc0 Posted messages 2173 Registration date   Status Member Last intervention  
 

No xl4 macros

0
Answer 6 / 8
cousinhub29 Posted messages 1112 Registration date   Status Member Last intervention   383
 

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
vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
 

No xl4 macros

0
Answer 7 / 8
cousinhub29 Posted messages 1112 Registration date   Status Member Last intervention   383
 

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
Answer 8 / 8
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