I haven't worked with macros yet. I am assuming they can be searched for permissions, usernames, id's or passwords also.
Macros can change controls and properties on forms and reports. Macros can also change existing data in the database tables, so be careful before you make any changes. I suggest making a back-up copy of the entire database.