https://strugglingtoexcel.com/2016/02/02/use-prompt-excel-vba/
Are you Sure? Get user's consent before running a Macro in Excel VBA for Beginners