I encountering a weird problem in an Excel 2007 VBA project I’m doing now.
Each time before I close the file, I compile and save. The next time I open up the .xlsm file again, I expect to see the “Compile VBAProject” command grayed out, but it’s not! Why does Excel still think the VBA code is un-compiled?
Has anyone here experienced this problem before?
Thanks.