Excel Sheet CommandButton

[kaokao1]

(Please Excuse my poor English).

Hello Friend,

Receive a cordial greeting.

Friend, please see if you could help me with the following thing:
I opened a Sheet of Excel, then I inserted a CommandButton on it, then I associated it with a Code, in such a way that when pick the button, the program runs.
So far, everything goes well.

Now, I want to create an executable (.exe) from this Sheet., because in the event, I put my program in the hands of people, I need to protect the Code associated to the button.

The idea is: the client opens the Sheet of Excel, he sees the CommanButton, in it, he fulls the cells of data, then he oppresses the CommandButton and obtains in the Sheet of Excel the results and graphics, and everything the mentioned Code, works.

Completely transparent for the User. He works all the time, in Excel.

Please, could You help me with this problem?
Thank you.

[kadghar]

(Please Excuse my poor English).

Hello Friend,

Receive a cordial greeting.

Friend, please see if you could help me with the following thing:
I opened a Sheet of Excel, then I inserted a CommandButton on it, then I associated it with a Code, in such a way that when pick the button, the program runs.
So far, everything goes well.

Now, I want to create an executable (.exe) from this Sheet., because in the event, I put my program in the hands of people, I need to protect the Code associated to the button.

The idea is: the client opens the Sheet of Excel, he sees the CommanButton, in it, he fulls the cells of data, then he oppresses the CommandButton and obtains in the Sheet of Excel the results and graphics, and everything the mentioned Code, works.

Completely transparent for the User. He works all the time, in Excel.

Please, could You help me with this problem?
Thank you.

hi,

you cannot create executables from VBA, but you can certainly protect your code from other people

In the vb editor, in your tools menu, you'll have the project properties where you can put a password to protect the code.

Hope that helps

[kaokao1]

hi,

you cannot create executables from VBA, but you can certainly protect your code from other people

In the vb editor, in your tools menu, you'll have the project properties where you can put a password to protect the code.

Hope that helps

*************** ***
I am very grateful for You. Thanks.
I'll try to find the way to do it. But we are working in VBasic, I liked, the user works in Excel because it's more popular.

Good Bye.