[RESOLVED] hiding vba code in outlook
Hey,
with this forum great help, I've managed to write a small vba code for outlook.
I would like to:
1. distribute it to other computers (I guess I can copy paste the code but I'd like to know a more reasonable way) and,
2. hide it from the users (so that if they press alt+f11 they won't see my code)
thanks,
Re: hiding vba code in outlook
From the VBA IDE in Outlook "Tools > Project Properties... > Protection tab > check "Lock project from viewing" > enter a password and verify > Ok".
Re: hiding vba code in outlook
great. that helps a lot. what about distributing the code to other users. do I export each object to files and then import them back, or is there a way to export/ import the whole project?
by the way how do I credit you in this forum?
Re: hiding vba code in outlook
If your users are not using any Outlook VBA code already then you can copy the .OTM file, which contains the VBA code for thisoutlooksession, and paste it in the users directory while Outlook is closed.
C:\Documents and Settings\VB-Guru\Application Data\Microsoft\Outlook\VbaProject.OTM
Edit:
Quote:
by the way how do I credit you in this forum?
You can do it by clicking on the "Rate This Post" link for the post you would like to rate, either positive or negative and supply a comment. Also, see the link in my signature on "Reps and Ratings" for details about the Rep system.
Re: hiding vba code in outlook
when pressing rate this post i get "you must spread some reputation before giving it to robdog" but that's the first time I've done this.
anyway, you're a true guru!
thank you,
Re: [RESOLVED] hiding vba code in outlook
I see that you havent rated me before. :confused: I need to have MartinLiss check this out to make sure its not a bug of somekind. I'll get back to you.
Thanks :)
Re: [RESOLVED] hiding vba code in outlook
Turns out that you did rate me back on 29th Dec 2005 14:13. So this means that you need to Rate 10 other members before you can rate me again.
Oh well.
:)