Hi R
Just had the same thing here...A button on a Userform that returns to a Master Sheet, clearly states "This will return you to the Main Menu....and in RED & BOLD on the button "No data will be saved"
When the button is pressed, a MsgBox pops up with....."No data will be saved. Are you sure you want to lose ALL data"
One of the engineers using the sheet, logged a call with IT ......wait for it ....because every time he fills in the data and goes back to the Main Menu, his data disappears.....it must be a bug in Excel !!
There must be a level of stupidity that can't be crossed !!!
I finally cracked....I have now put a series of MsgBoxes in the script, so that when this one user logs in, it asks about 6 times "are you REALLY sure you want to do this"
He's starting to get a little peeved.....but give him another few days, and I reckon it will be lesson learned !!