Treeview control randomly deleted itself

[Jerbinator]

Hi all,

I have a very complex database set up that is meant to track all the training that happens in our workplace. It has a ton of userforms in it, including one that has two different treeviews on it.

This morning a user emailed me and told me this particular userform wasn't working. I checked it out and discovered that both treeview controls had been deleted somehow. I have my code password-protected and locked, and nobody in my building understands VBA except me anyway, so how on earth did this happen? Has anyone had a treeview just randomly disappear before? I know my listboxes on the various userforms are constantly resizing themselves, and I had to put code into the initialize command to resize them every time they're viewed, but I've never had a control flat-out disappear.

Should I just write code to create the treeview every time, rather than trusting it to stay put? It creates some serious problems when it's not there. Thoughts?

[Jerbinator]

I would like to add to this that other odd things have happened with this database. For example, listboxes on userforms have resized themselves. And it's not like they resized themselves at runtime, either: I've opened the things in design mode and they are changed there as well. Nobody else has access to design mode in this workbook, and no one at my workplace is capable of doing that anyway. Most of them don't even know how to build a table! And then today, I opened the workbook and discovered it had deleted a monthview calendar out of nowhere. This was in my backup copy of the workbook, which nobody uses but me, and I sure as heck didn't delete it, so clearly the workbook is doing it to itself. It's like the thing is possessed! Has anyone else seen anything like this??

[Jerbinator]

I was just looking over the database again. The treeviews on every userform have re-deleted themselves. All of the monthview calendars on every userform have deleted themselves. And all of the listboxes on every userform have resized themselves so you can only see the first selection when you look at them. WHAT IS GOING ON?