VBA and Basic code in a Calc spreadsheet ?

[jcproperty]

Hi everyone,

I have a Calc spreadsheet with a set of macros in VBA, attached to the document worksheets with the VBAsupport 1 option.
Since it didn't work properly and since I couldn't translate all the macros in BASIC (lacking time and knowledge), I tuned the code and added new macros in pure BASIC, called from the VBA code. But the BASIC macros don't seem to be willing to work in the Standard module of the document, I had to put them in the Standard module of "My macros and dialog boxes" for them to work.
Does anyone would know the reason to why I can't put BASIC macros in the standard module, while I have VBA macros attached to the sheets ?
Thanks.