How to execute VBA code without open visual basic ediotr

4305 views excel
-1

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?)

answered question

1 Answer

8

There are multiple options: - you can make a button like you said - you can ask the user to execute the macro via the developer tab - you can make a macro that executes upon an action, for instance sheet activation, cell change, opening a file, ...

posted this

Have an answer?

JD

Please login first before posting an answer.