Excel 2010 UserForm Deleting Automatically

[sanmisds1]

Hello,

I know I am not crazy yet. Last 2 days I have been creating a userform and saving them along the way. Yesterday, while deleting one of the userforms that I did not needed the main form got deleted and when I close the form with do not save option, it got deleted anyway. Today, I recreated the form from the scratch and had the form all ready and saved. In the worksheet area I was inserting some data (Country list) from web excel file and while doing so excel crashed and when reloaded my form was gone. What is going on? Is this form somewhere hidden as part of excel 2010 feature? I have never experienced something like this in Excel 2003. Please suggest. Thank you !!!

 

[sanmisds1]

Hello Any idea? Thank you !!!

 

[chrisbelfast]

Hey there

Ok first question will be a "have to check" question.
Are you looking under VB in the workbooks forms folder?

Also where was the file from? If you opened the file from say outlook it will be stored in a temp folder within outlook, this can then cause the file to be deleted if you havent saved it else where after a few days.

You also mentioned a web excel file, were you working with the userform online? Or taking information from the web?

Chris