Protect macro code from viewing/editing

[Keith]

In older versions of EXCEL I was able to password protect
my VBA code so that users couldn't access to
read/copy/edit. I can not find a way to do this in EXCEL
2002.

Any help would be appreciated.

k

 

[Mario]

hi keith
very easy
go to EXTRAS - Properties of VBA project - protection


kind regards from AUSTRIA (graz)

mario

 

[keith]

Mario's answer didn't get me there. Anyone else care to
chime in??

keith

 

[Chip Pearson]

Keith,

In the VBA Editor, go to the Tools menu, choose VBA Project Properties, then
the Protection tab. There, check the "Lock project for viewing" option and
give it a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Keith]

I had tried that before and can still go right to the
code from the EXCEL workbook.

Any other thoughts

Keith

 

[J.E. McGimpsey]

You'll have access to the project until you close and reopen the
workbook.