Thanks abcd
--
Ahmed El Hadary
Financial Analyst
Qatar National Hotels
Mob. 0974-5289491


"abcd" wrote:

you mean you wish a macro to do something when macro are not executed ???

This is the idea of security High. You may wait for the user to change
this, but you can not change it by yourself.

BUT you may sign your code and then always accept the signature (in
high level: only signed code may be executed). So your only way is to
sign it...

1- create a local auto sign key pair on your PC: for that purpose go to
the Office folder in Programs and run
....\Microsoft Office\Office\SELFCERT.EXE

2- in the VBA editor, sign your code with your key. (tools menu)

3- make the security level medium, close, reopen the file.
Answer you wish to "always trust this signature..."

4- put again the level high


step 3 and 4 need to be done with each user's PC.