Compile error in hidden modules: ModPrivate
The error message you mentioned commonly occurs when there is an issue with the PopTools add-ins installation. One possible solution would be to reinstall the PopTools add-ins for Excel.