Open an Excel document or WPS-type spreadsheet document with WPS, then click Development Tools at the top.
2. Then you can see [macro], [record new macro], [macro security], [VB editor] four options, are related to macro, here click the \"macro\" button.
3. In the new dialog box, enter the macro name and click the Create button.
4. Then it will jump to the VBA editing interface, where the code can be written.
5. After writing the code and finally saving the file, a message will be displayed indicating that the following contents cannot be saved in a workbook without macros enabled, because the current format is xls or xlsx. Then click the [No] button.
6. Finally, save as, select the format as xlsm, that is, enable macro workbook, you can save successfully.
Open the Lightning simulator, click the button on the right bar, find the \"one-click macro\" button, click and drag to the simulator window where you want to put it to start...