Not sure whats its called so maybe you can tell me ??

[ipbr21054]

Evening,

I have a worksheet with a code which works fine.

Now this is what i cant remember / dont know the name of.

I need to have say an EXE file which has this code inside.
So as opposed to the user seeing the bare bones on a worksheet it will be in something like a userform with my working code in the background.

Do you understand where im coming from ?

Thanks

 

[mole999]

try this > https://doneex.com/how-to-compile-workbook/

 

[ipbr21054]

Thanks for that.
I followed the video but my AVG flagged it as a threat and disabled it.
This was the saved file of which the software produced.

Now when i click on the file it just crashes.

Looking at his example i think it wasnt what i required.

Many thanks for replying here anyway

 

[mole999]

I thought it was a compiler you needed to buy for it to work, don't know how it handles spreedsheets and being able to store the data back

 

[ipbr21054]

I am not sure exactly what its called BUT use this as an example.

I wish to send a customer a file of which would look like a userform where they enter a few numbers into a text box ,press a button to then be shown a code in another text box.

My worksheet is the bare bones of the code & all can be seen etc,But i dont want them to see any of that.

So all they would see is a look a like userform with say 2 text boxes & a command button.

They dont need to see my text, format, etc etc.
They just enter a number & press a button then my code of which they cant see then does its stuff and puts the code into the text box.

 

[Logit]

.

Option Explicit


Private Sub Workbook_BeforeClose(Cancel As Boolean)
     ThisWorkbook.Application.WindowState = xlNormal
     ThisWorkbook.Application.Visible = True
End Sub


Private Sub Workbook_Open()
    
    FormOnly
   
End Sub

There is more code. Review the workbook contents, download link : https://www.amazon.com/clouddrive/share/GbRY7MtYLTCYSAiLgYzdH2dDjubKM4GYA6ub3mjX3Oh