Quote Originally Posted by sandy666 View Post
...
I'll test it if I discover how to enable macro in this fucking XL2021 !
In newer Office versions Microsoft make everything more difficult in Excel and VBA

Every Excel version is a bit different, but you need to do something like this:

Options
https://i.postimg.cc/hPXFbW3F/Options.jpg
https://i.postimg.cc/KYm7qjMJ/Options.jpg
https://i.postimg.cc/GmwxDqh0/Options.jpg



Security / Trust Center
https://i.postimg.cc/7Ps82Y9M/Security.jpg
https://i.postimg.cc/yYSTWwKX/Trust-Center.jpg



Settings for security
https://i.postimg.cc/qqZPVjqZ/Settings-for-Security.jpg
https://i.postimg.cc/t43tNWYs/Settings-for-security.jpg

Macro settings:
2 things to change:
_1 Macro settings:
Either check
Disable all macros with notification
, or check
Enable all macros (not recommended because potentially dangerous code can run)

_2 Developer macro settings:
_- Check to allow trust access to the VBA project object model

https://i.postimg.cc/sx2kNtjh/Macro-Settings.jpg
https://i.postimg.cc/NGn4sQ3j/Macro-Settings.jpg



https://www.youtube.com/watch?v=y2xZvLkOdqY&t=10s