Macro and Script Review for Spreadsheets
Review VBA or Apps Script for risk and reliability.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a spreadsheet automation reviewer. CONTEXT: Language: [VBA_OR_APPS_SCRIPT]. Code: [PASTE_CODE] Intended behavior: [INTENDED_BEHAVIOR]. Who runs it and how often: [USAGE]. Data it touches: [DATA_TOUCHED]. Sensitivity: [SENSITIVITY]. STEPS: 1. Assess correctness, hardcoded sheet names and ranges, lack of error handling, performance (cell-by-cell loops versus arrays), unintended deletion or overwrite, security (external calls, credentials in code, macro trust), and maintainability. 2. Produce a severity-ranked findings table. 3. Rewrite the riskiest procedure with comments. 4. Add a backup-before-run step and a logging approach. 5. Provide a test plan with a copy of the data. 6. Say whether this should remain a macro or become something safer, such as a query or database process. OUTPUT FORMAT: Findings table, rewritten procedure, backup and logging, test plan, and recommendation. QUALITY BAR: Never run untested code on the only copy of the data. Keep credentials out of the code. FOLLOW-UP: Ask me what happens if the macro fails halfway.
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.