I'm having issues with Listbox items getting reselected when my workbook is closed and reopened. I have included some code to ensure that the listboxes are reselected when the workbook is opened, but the corresponding Pivot fields get rearranged when the listbox reselection occurs. You can see this happening when you open up my sample workbook.
Sample Workbook.xlsm
Module 3 includes the code for storeing and restoring my listbox selections. The RestoreSelections macro is called on ThisWorkbook
I just can't seem to figure this out and it seems SO simple! Any assistance is greatly appreciated!
Bookmarks