You can create Excel addins which sound similar. You can also protect a
whole project, not specific sections (right-click the project in the
VB IDE,
and select Properties), but it is simple to crack. It is sufficient to deter
the casual browser, but do not rely on it.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"HLong" wrote in message
...
I am use to work in AutoCAD VBA, now I need to create some routines in
Excel
and I have some questions. I would appreciate if someone could give a
hand.
Is there a way of creating project files in Excel like in AutoCAD, which
you
could load everytime Excel is loaded and add password protection?
How could I protect my code on the Sheet or ThisWorkbook object?