Overall, the choice between VBA and Python for Excel automation depends on your specific needs. Even though it's outdated, ...

After setting the password protection for the VBA project, ... try accessing the VBA Editor by pressing `Alt + F11`. Excel should prompt you to enter the password you set earlier.

Go to Excel Options > Trust Management > Macro Settings and make sure the following option is enabled: Trust access to the VBA project object model. The code also requires the below references namely ...