Hiding code

[Maximilian_Slade]

I am working an a complex database.

I have created specific functions (Public <function name>() as...) whose code is stored in table fields. When some of these specific functions are needed, I read the table content, dynamically create a new module, put the function code within, make an Eval(<function name>) to get a result, and erase the dynamically created module.

My problem is that the VBA editor window is launched. Is there a way to prevent its display (by code or something else)?

[Bob Fitz]

I am unable to answer your question but I am curious as to the need to do this. Why don't you just keep the funtions in module?

[Maximilian_Slade]

The functions' code have to be stored there (in a table) to allow their modifications on different regional sites. That prevents a de-synchronization of the application core code and a whole mess (and a lot of developer work) with new version releases. It brings flexibility.

What I found now is, just after the creation of the dynamic module is a
SendKeys "%" & "{F4}" 'Send CTRL + F4
that will quickly close the Microsoft Visual Basic Editor. But there is still a flickering of screens. So I am still searching.