Abacre Home > Advanced Find and Replace Home

How to search and replace in Microsoft Excel macros?

In order to find and replace in MS Excel macros you should authorize AFR to do that.

Please open Excel and go to
Tools->Options->Security->Macro Security->Trusted Sources

There, on the bottom, check ON: "Trust access to Visual Basic Project"

Then start AFR and in main menu -> Action -> Options -> Advanced, check ON: "Search and replace in Office Macros"

See also: General options | Find options | FAQ