I'm new to these forums (and VB
/VBA) so please bear with me if I'm not doing this correctly. I've designed an application that runs on a form (in vba) but I don't want anyone to see my code, I just need to activate the form automatically. Is there a way of doing this? A friend of mine suggested that I port my code to VB6 and then save it as an executable but this is too much work for me cuz there'll be a lot of compatibility issues etc.
Currently, I run the excel file and then press 'ALT' + 'F11' followed by 'F5' to activate the form. However this means that anyone that does this can view the source code and i understandably don't want that. Is there an Excel switch that can do that, or some Add In? Btw, I know very little about add ins.
I look forward to reading your responses.