Help need on programming in Excell using VB.

4 posts · originally from https://geek.digit.in/community/threads/help-need-on-programming-in-excell-using-vb.88794/

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

*www.ozgrid.com/VBA/protect-vba-code.htm

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.

Thank u all....

Thank u very much for ur help.