Help need on programming in Excell using VB.

[beginner]

Hello Guys,

I created one programme file in Excell using VB, Im not able to protect VB Editor where I put my comments and functions, my friends are editing my programm hence I need to protect my programm with Password but I dont know please help me to protect my program by giving password.

Friends, I need one more help, In this programm i m displaying results in a worksheet, when i'll press submit button on that result sheet, I want that result worksheet will save in a specified folder.

Please help me to improve my programm and my knowledge

Thank U

[dheeraj_kumar]

http://www.ozgrid.com/VBA/protect-vba-code.htm

[QwertyManiac]

Doesn't the Worksheet object have a Save method? Object.Save("Path\to\file") should work, normally.

SaveAs also exists for certain other objects, do find out via the easy drop-down that comes post the dot.

[beginner]

Thank u all....

Thank u very much for ur help.