Im stumped... This all started with my excel 2010 not retaining my option to "Enable AutoComplete for cell values" after I close a workbook. So I wrote an addin (*.xlam) to handle excel events using a class module to always enable auto complete upon workbook open. Or so I thought on workbook open... for some reason the event workbook open and workbook before close events do not work. I know they run because I've run them all individually with a msg box and they all appear. When it comes to setting the enable auto complete property only the selection change event works for me.

I've shown a couple variations of when I was trying to enable auto complete. Can someone explain why only the selection change works? I would have figured once the class was initialized and "App" was set to the application I could set that property at any time after. What am I missing?

Add-In Code: ThisWorkbook
Please Login or Register  to view this content.

Add-In Code: Class Module - clsExcelEvents
Please Login or Register  to view this content.
Does NOT work
Please Login or Register  to view this content.
Does NOT work
Please Login or Register  to view this content.
WORKS!
Please Login or Register  to view this content.