View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Astra Astra is offline
external usenet poster
 
Posts: 2
Default Protecting my VBA based query programming

Hi All

I've created quite a number of ADO/SQL/Query routines in the VBA/Macros side
of MS Excel for PC so that buttons and fields on the Worksheet query SQL
databases and this works fine.

My problem is that anybody can see and 'extract' the work that I've done by
going to Tools/Macros/Visual Editor and looking at in the code.

Is there any way I can disable/stop people from seeing the code side of a
workbook when I send it to them without affecting how the rest of the
Workbook works?

Thanks

Robbie