Sam

ALT + F11 to get to VB Editor.

CTRL + r to open Project Explorer.

Select your project/workbook.

Right-click and VBA Project Properties.

Select Protection tab and follow your nose.

Workbook must be saved at that point.


Gord Dibben Excel MVP

On 24 Apr 2005 08:23:24 -0700, "Sam" wrote:

lock the vba for editing : how do i do that ?

Thx !