Hi and welcome to B B
this problem was discussed here many times. So please use the BOB’s search functionality to find what you need:
Hint: in search use for example these keywords vba, default, prompt
and you get for example this thread:
Marek
Marek Chladny (BOB member since 2003-11-27)