Hey, so far so good.
but in case you do an ...SaveAs ...
FileFormat:=xlExcel4Workbook ... you get an error 1004.
This error you won't get with an unprotected project.

Does someone know how to make a copy of the original
workbook (in vb), without copying the macros ?

or

how to unprotect the VBProject-Objekt (in vb).

thank you guys
manfred

-----Original Message-----
n the VBE select Tools/VBA Project Properties to open the
properties window. Select the Protection tab. Check the
Lock fro viewing box and add a pasword. Use a long
password ( at least 10 characters) and use letters,
numbers and punctuation.

"ABC" is easy to crack

abC!D_45?7alPaka may take a while

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi...

I've written loads of juicey code but want to protect it
from users hitting alt+f11 and nicking it? And if I
disabled alt+f11 how would I get back into it...Helk in
VB
editor not too helpful...

JC
.

.