Macro to export modules does not work

[renatoab]

I want to have text files (.bas, .cls) with the updated version of my codes in a xls file.
I guess I can't do a reference from the xls to the files and run the codes from the text files. The code must be in a module in the xls.
So my idea was to write a Sub Workbook_BeforeSave. So, everytime I save the xls file, it would run the code inside it. And there I would put a macro to export my modules.

I have searched macros to export my modules, but they don't work for me.
They are based on the VBProject property of ActiveWorkbook (or ThisWorkbook). (One example is in http://edndoc.esri.com/arcobjects/9.0/Samples/Application_Framework/ExportVBACode.htm)
I enabled the needed reference to do this ("Microsoft Visual Basic For Applications Extensibility").

But when I run, I get a message that the access to the VB project is not reliable.
Is there anything I can do?
Thanks

Using:
Excel 2003
Windows XP

 

[Jaafar Tribak]

Go to Tools-Macro-Security-Tick the "Trust VB Project" checkbox under the second tab.

Regards.

 

[renatoab]

Very good.
Thank you, Jaafar
It's working now.