go to tools-macros-visual basic editor. Right click Microsoft Exce
Object which is below VBA project-click VBAProject Properties -clic
protection tab- select "lock project for viewing", enter password an
confirm password and click ok.

save the workbook, close it and open it again.

Now you won't be able to see the code unless you type in password

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=31939