Provide two workbooks. The first workbook's sole purpose is to open the "real"
one.
But put the first workbook somewhere that you can publicize. The user will get
see that drive/folder. And if they allow macros to be run, then the other will
open with no verification.