I mean the VBA code behind a macro in the Excel sheet so other people will
not be able to see the code while still able to run the macro?

Thanks a lot

Right click the module name. Select project properties, then the protection
tab

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


cfman wrote:
> I mean the VBA code behind a macro in the Excel sheet so other people
> will not be able to see the code while still able to run the macro?
>
> Thanks a lot

Open the Visual Basic Editor (Alt/F11)
Right click on the VBAProject(YourProject) in the left hand pane.
Select VBAProject Properties.
Click on the Protection tab.
Check "Lock project for viewing."
Enter a password twice.
Click OK.

Regards,

Alan


"cfman" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I mean the VBA code behind a macro in the Excel sheet so other people will
>not be able to see the code while still able to run the macro?
>
> Thanks a lot
>

With your workbook open.

Alt + F11, CTRL + r

Right-click on your workbook/project and "Properties"

Select "Protection" tab and "lock project for viewing".

Enter a password.

Note: workbook must be saved/closed and re-opened before the locking takes
effect.


Gord Dibben MS Excel MVP

On Thu, 1 Mar 2007 18:18:52 -0800, "cfman" <(E-Mail Removed)> wrote:

>I mean the VBA code behind a macro in the Excel sheet so other people will
>not be able to see the code while still able to run the macro?
>
>Thanks a lot
>

Open the IDE (alt F11)
Select Tools then VBA Project Properties
Then select the protection tab, and lock the project for viewing

"cfman" wrote:

> I mean the VBA code behind a macro in the Excel sheet so other people will
> not be able to see the code while still able to run the macro?
>
> Thanks a lot
>
>
>

cfman <(E-Mail Removed)> wrote:
> I mean the VBA code behind a macro in the Excel sheet so other people will
> not be able to see the code while still able to run the macro?

You mean, those three "other people" who don't know about Google?
--
..NET: It's About Trust!
http://vfred.mvps.org