How to skip 'Compile error in hidden module' error message

[lrutt]

I have a workbook that was written in 32bit Excel and I'm trying to upgrade these sheets to work for 64 bit excel. The code that I need l find and replace is the following: find = "Private Declare Function", replace = "Private Declare PtrSafe Function".
Problem is when I open the 32 bit sheet I get the error and it won't proceed. How can I get around that? If I can work abound that the rest of my upgrade script works and I can move forward I have dozens of workbooks to upgrade.

Thanks

 

[lrutt]

I've continued to try options for error suppression to no avail. Any help would be appreciated.

 

[Yongle]

maybe this ...

in VBA editor window \ Tools \ Options\ Editor tab - uncheck the Auto Syntax Check box
Close and restart Excel

 

[lrutt]

Thanks so much. That seems to have worked. I updated 1 workbook on my 64 bit machine with no errors.