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
Add-In Code: Class Module - clsExcelEvents
Does NOT work
Does NOT work
WORKS!
Bookmarks