I have a worksheet that populates cells based on user choices from combo boxes. When a user chooses to rename the workbook by using the "Save As" from the file menu, the macros tied to the drop down boxes run, and any data on the worksheet is erased. If a user just chooses to "Save" the file the macros do not run, and the worksheet is fine.

Is there a way to prevent this?