Excel 2007 : Code Deleting unintended buttons on main spreadsheet

Hello,
I have created a test file that I hope to implement in an inventory database. Everything seems to be working as it was designed, except when you use the "add or replace equipment" function. For some reason when you input the required information and click "replace", it deletes the "search", "show all", and "click here to add new equipment" buttons on the main sheet. It seems to have to do with their location on the sheet because if I move them to a different spot, this does not occur. After mulling over the code for hours, I still cannot figure out why this is happening.

Any help would be greatly appreciated. Please see the attached file...

I have ran across unusual behavior with the buttons in the past. Generally my symptoms were that the button would grow bigger when a user clicked on it over time till it covered the rest of the buttons -- for the life of me I could not figure it out. This only happened when buttons were close to each other on the sheet.

I gave up trying to figure out why? My solution was to reset the location, height and width of each button anytime it got clicked.... not pretty but it worked. You may want to try something similiar if the experts here do not have a better solution