I am running macro-enabled Excel file in one of the server computers in my anization. When I try to use the Find option in VBA developer window, it does not work.

For example, when I use Ctrl+F or Edit -> Find and then try to find a text and click Find Next or Enter, the message box just disappears without going to the next match. Even while selecting current procedure, current module or current project, it is the same.

When I select Edit -> Find Next, it gives Out of Memory error. I am not sure if this is related to the issue that the Find command is not working.

This is very strange as the Find command works normally in other computers. What could be the cause and potential fix for this?