Search results

Hi Roberto, in my case simple ThisWorkbook.save worked out well in the end. Let me know if this helps to solve your issue, Cheers Jan

Click.png743×606 65.6 KB Finally the problem was that I had only second option ticked. The first option has to be ticked as well. Sorry for that. Thanks for your support.

Still the same-works in excel but not after compilation with your app. Do you test the code you recommend? Does the code work for you?

Nope, still doesn´t work. Again, it works in excel however once I compiled it to .exe file the value doesn´t get saved. My updated code: Private Sub Workbook_Open() UserForm1.Show End Sub Private Sub CommandButton1_Click() Unload Me End Sub Private Sub TextBox1_Change()...

Still doesn´t work for me. I made a new simple vba to check whether there is a issue with my code however it seems to be doing exactly the same. The VBA consists of userform with one textbox. Anything what I write to textboxt gets written in A1 cell. Once I cancel the userform the workbook gets...

Hi. I´ve been recently trying to use your new save function “Save changes automatically and load them without prompt next time” on my compiled .exe VBA project. However without success. On userform_terminate I would like to automatically save the file so all the changes within workbook will be...