Just a guess: from an Excel tab, click Tools Add-Ins and make sure
"Analysis Toolpak- VBA" is checked. Then compile your code again.
Hope that does it for you!