I have a 2007 worksheet in which several ActiveX multi-select list boxes are embedded (not on user forms). The list boxes are sourced to a defined range and I have vba code that captures the selections so the check boxes can be re-populated each time the worksheet is opened using the last selections that existed when the file was saved.

When a user chooses to Save the worksheet, the list box selections in place are saved and remain visible after the Save event. However, when the user chooses Save As, the list box selections clear before your eyes during the Save As event. If the file is then closed and reopened, the most recent selections are repopulated via the vba code and all is back to normal. So they don’t clear during Save, but do clear during Save As.

My question is: What triggers the clearing of list box selections?

If I set up just the list box and supporting vba code in a basic spreadsheet, it works fine during both the Save and Save As events. So I’m thinking that something I have in my code may be the culprit, but I don’t know what to look for. Any help or direction would be appreciated! Many thanks!