Recently, several people have reported that the RegEx Find/Replace add-in for Excel has stopped working, displaying the following error message:

Compile error in hidden module: ThisWorkbook

The error appears to be a side effect of a recent update released by Microsoft. I don't know the details of exactly why this broke the add-in, and I'm not sure if it's caused by a Windows update or a Microsoft Office update. However, after scouring the Internet for a while, I came across a solution. Here are the steps to restore the add-in's fu...
Continue reading ...