View Single Post
  #29   Report Post  
Posted to microsoft.public.excel.programming
witek witek is offline
external usenet poster
 
Posts: 147
Default Better protection for VBA project?

GS wrote:
GS wrote:
Of course, there's always the option to go DLL or COMAddin!


I did it about 7 years ago.
I moved all calculation logic to C++
Unfortunately a couple of things must stay in VBA or we simply do not
want client to add anything to VBA.

What I do is more like document facing project . File can be send
around the world.
I can't install anything. All VSTO or DLL requiring registration with
admin right can't be used.


Not even if your installer runs with elevated permissions?


Clients do not have rights to install anything.
They work on virtual desktops and every time they login they see brand
new computer. Nothing stays except data on shared drives.

They other reason is that they do not want to install anything.
They want to open excel file, do their work and send that file to
another person.
I call that iPhone syndrome. One button click and nothing more advanced.