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" wrote in message
...
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" 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 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