Protect workbook structure — AI Prompts for Microsoft Excel

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

I need the workbook locked so no one can add, remove, or move sheets. Protect the workbook…

I need the workbook locked so no one can add, remove, or move sheets. Protect the workbook structure and windows with a password I will give, but do not lock individual cells yet. Make sure existing hidden sheets stay hidden and that the VBA project remains accessible only with the same password. Save a copy named Quarterly-Forecast-Protected.xlsx and confirm the protection works by attempting to add a sheet and capture the error message.

Improve — make it easier to accept

Before I roll this to finance, make the structure protection easy to approve. Highlight what…

Before I roll this to finance, make the structure protection easy to approve. Highlight what changes will be blocked (adding, deleting, renaming, moving sheets) in a two-line summary at the top of the file. Add a note on who to contact and the password change process, and ensure the hidden sheets remain hidden after protection. Flag any sheets that contain external links that could break when the workbook is locked.

Decide — diagnose the stuck moment

I locked the workbook structure and the analyst reports they can’t add a cover sheet; I don’t know…

I just protected the workbook and the analyst says they can’t add a cover sheet.

I locked the workbook structure and the analyst reports they can’t add a cover sheet; I don’t know if they need to edit the VBA or just add a sheet temporarily. What likely caused this, and what is the fastest way to let them add the sheet without losing the protection for finance?

Become — change the pattern

Every quarter we finish reports, protect the workbook structure, and then analysts scramble because…

Recurring friction when analysts need to make structural edits after protection.

Every quarter we finish reports, protect the workbook structure, and then analysts scramble because they still need to add small sheets or restore hidden ones. Help me change the habit: what simple process or rule should we adopt so structure protection doesn’t bottleneck last-minute edits yet the workbook stays secure for distribution?

Next to this one

Other spreadsheet work people do in Microsoft Excel.

Print selected ranges neatly Process incident reports for prevention Process invoices for payment.Produce statistical reports and visualizations Propose risk preventive measures to health policy organisms Protect worksheets from edits Provide analytical support for preservation efforts Provide other tax-related advice in reference to current legislation Provide recommendations on financial matters Purchase investments for companies in accordance with company policy.

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.

The rest of the map

Same library, five ways in.

Work Atlasthe whole map, interactive Careers1,949 jobs and their real tasks Soft skillsthe human part of the work Activities500 things people do Prompt Librarybrowse every prompt