Hi

You can do it in vba
tools - VBA properties
insert project name
sheet protection : insert pasword
if there is a bug, you even can't choose debug and so
can't enter the macro's

good luck
Tom

-----Original Message-----
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


.