I am currently developing a program to read excel. However, I have a few validation points that need to be validated in both java and excel. Hence, I want my excel to validate some simple logic for me on excel file.
Here is a question. I am going to distribute my excel file which includes my VBA code, How does my user execute the validation code?
I don't want my user to open the visual basic editor and run it.. is there any simple way to do that?
(** i found that there is a way to insert button... is that only way?)