add a variable on modul level then
in workbooks open event set its value that would store info about msgbox
appearence (e.g. string variable set to "N") - after selection you will
check wheather this value is set to "N" - if so the msg appear and the value
of that variable would be changed to "Y"