Hide values of functions in VB Editor

[Lammutaja]

Hi!
Can anybody give me a suggestion how can I totally hide
values for specific function from user viewing when during executing of VBA program (in Immidiate window, watcshes, Locals,...)?

I have next problem:

I have database and user should not access username, password and some Database string from some .xls file (from VB Editor). These parameters are in some protected .xla file as public function values.

Regards,
J?ri.

[malik641]

Hi J?ri and welcome to VBAX

What exactly do you mean by hide? If the user shouldn't even see the code at all, then why not protect the project?

[Bob Phillips]

You can protect a VB project, but this is far from foolproof.

You could also use some encrypting, but this is complex and the key would have to be stored somewhere.

The safest way is to create a VB6 DLL with the critical data and access it via the VBA code. But remember that anyone else could call it in the same way.