Create EXE for Toolbar created using VBA

[SpencerTrevor]

Good day all

I have created an toolbar in ArcMap and create few function/button using VBA. This toolbar I need to pass it to my client, is there a way to create an EXE file so my client only need to install the EXE file.

any help will do

Thank you in advance

[NeilClemmons]

You cannot compile VBA code, so no you can't do that.  If you want to distribute VBA to someone else then you will need to give them an ArcMap project or template that contains the code (or manually copy your code into their environment).