stop functioning insert function and copilot function

Question

hello everyone

in excel stop functioning insert function and copilot function after opening micro enable file

now i am not be able to insert new row and column between two row and Colum please help how to fix this issue

Answer 1

Thanks for sharing the details! Try to force Excel back into Normal Edit Mode

This resets Excel’s internal command state without touching protection, sharing, or macros.

Step-by-step

Open the problem workbook

Press Alt + F11 (opens VBA Editor)

Press Ctrl + G (Immediate Window)

Paste exactly this and press Enter:

• Application.CommandBars("Cell").Reset
• Application.CommandBars("Row").Reset
• Application.CommandBars("Column").Reset
• Application.CommandBars("Worksheet Menu Bar").Reset

Close VBA Editor

Close Excel completely

Reopen Excel and the file

Some macro-enabled files:

Modify right-click menus

Disable Insert commands

Never restore them when closed

Excel remembers the broken menu state, even for new sessions.

This fix rebuilds Excel’s internal command bars, which none of the usual fixes touch.

See if this helps. If you need further assistance just let me know.

Best regards,

Kimberly