How to activate macros in WPS Spreadsheets 2021 in Ubuntu 20.04
Sophia Terry
I'm trying to compare LibreOffice version 6.4.7.2 Calc with WPS Spreadsheets in terms of how macros are handles. I imported an Excel spreadsheet containing many macros into WPS Office Spreadsheets 2021. I'm referring to the Personal Edition of WPS Office Spreadsheets. Macros do not work because they are not enabled. How do I enable all macros, and edit them in the WPS Office Linux version 11.1.0.10702? I've used macros in Excel for many years, and I'm looking for a replacement spreadsheet as I continue to become Microsoft free.
21 Answer
You cannot enable or use Macros in the Free/Personal/Business version of WPS Office 2019. The only version that supports Macros is WPS Office Enterprise Edition/Version. This is not available on their website. You have to buy it from you local WPS distributor.