LibreOffice Calc VBA Macros Not Working

How to fix it

// try these in order, the most common fix is first

1. FIX 1Check macro security

   Copy steps
   1. 01Tools > Options > LibreOffice > Security > Macro Security: set Medium
   2. 02Reopen the file and choose Enable Macros
   Did this fix it? Yes No

2. FIX 2Enable VBA execution

   Copy steps
   1. 01Tools > Options > LibreOffice Calc > Formula
   2. 02Tick Execute Excel 2007 and newer macros under VBA Properties
   Did this fix it? Yes No

3. FIX 3Save as ODS and port macros

   Copy steps
   1. 01Save the workbook as .ods
   2. 02Rewrite code in LibreOffice Basic or Python using the UNO API
   Did this fix it? Yes No

4. FIX 4Keep a copy in Excel

   1. 01Run the macro workbook in Excel for production use
   Did this fix it? Yes No

Symptoms

Buttons, userforms and macros in an .xlsm do nothing, or macros disappear after saving.

Why it happens

• C-01Different object model from Excel
• C-02Macro security level blocks macros
• C-03xlsx format can't store LibreOffice Basic macros
• C-04Unsupported VBA keywords

// this guide also covers

• libreoffice vba macros not working
• libreoffice calc macro xlsm
• libreoffice excel macros

Other LibreOffice errors

• LibreOffice Won't Open or Crashes on Startup
• LibreOffice Messes Up Word DOCX Formatting
• LibreOffice Impress PPTX Animations and Fonts Not Working
• Why Is LibreOffice So Slow to Start?
• LibreOffice Calc Slow or Not Responding on Large Files
• LibreOffice Document Could Not Be Locked Error
• LibreOffice Crashing or Not Opening on Mac
• How to Recover an Unsaved or Corrupt LibreOffice Document