Macro Safety and Maintainability Audit
Review recorded macros before sharing a workbook.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Review the macros in a workbook. Code pasted with comments removed of any secrets: [MACRO_CODE]. What the macro is supposed to do: [PURPOSE]. Who will run it and on which files: [USERS_FILES]. Check for destructive actions without confirmation, hardcoded paths and sheet names, missing error handling, unprotected sensitive data, calls to external programs or the network, and code that is hard to follow. Explain what each section does in plain language. Do not write code that bypasses security controls. Return a table with Section, Risk (red, amber, green) and Recommendation, a score from 1 to 10 for safety and maintainability, and a test plan using a copy of the file. Also check that the file's trust settings and storage location are appropriate. Report findings so the owner can fix them: describe the weakness class and the remediation, not a working attack. If a finding looks like a live compromise, tell me to isolate the system and involve the incident owner.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.