Hello again and thank you for your replies.


Answering to macropod:


by following the template method, I cannot achieve the level of security I am trying to.


Anyone can follow the path to the source code (the .dotm file) by opening the "Document Template" menu from Developer tab or throught File -> Options -> Add-ins -> Templates -> Go.
Furthermore, the source code is accessible to anyone from the Visual Basic Editor if they open it.


It's well known that the password protection system of office documents is not quite robust, therefore I came up with the suggested solution as described in post #1.
If you think about it, it's unbreakable (thanks to converting the Excel code to binary form).


Any other thoughts?




Answering to logit:


correct me if I am wrong but the code you are suggesting is not solving the problem.
I don't really want the intermediate Excel file to become active, but rather the original document ("A") since many Lines in my code start with the "ActiveDocument." prefix.
I am willing to change that however (making "A" not active while the macro is running) if a solution is to be found.




Is what I am trying to achieve feasible afterall?


Thank you all.