Support

How to Use Macros and Other Developer Functions in Spreadsheets 2013

Create Macros

To set macros in Kingsoft Spreadsheets, follow the steps below:

Step 1 Click the Macros icon in the Developer tab, or in the View tab. The Macros dialogue box will open and show as below:

use macros in spreadsheet

Figure 1 The Macros dialogue box

Step 2 Enter the macro name in the Macro name enter box.

Step 3 Select the range you want to apply the macro in the Macro in drop-down list.

Step 4 Add description for this macro in the Description enter box.

The options at the right side of Macros dialog box are shown as follows:

Run: Click to run the current macro.

Edit: Click to edit the macro in Microsoft Visual Basic.

Delete: Click to delete the macro.

Options: Click to add shortcut key for the macro.

Click Cancel to exit.

Set Macros Security Level

In Kingsoft Spreadsheets, you can set security level for the macros, follow the steps below:

Step 1 Click the Security icon in the Developer tab. The Security dialogue box will open and show as below:

use macros in spreadsheet

Figure 2 The Security Level tab

Step 2 In the Security Level tab, choose Very High, High, Medium, and Low according to your needs.

Step 3 Click OK to complete the operation.

Other Functions

Visual Basic Editor: Click to open the Visual Basic Editor and edit the macros there.

Add-Ins: Manage the Add-Ins available in this file.

COM Add-Ins: Manage the COM Add-Ins available in this file.

Design Mode: Enter design mode to edit control’s name and functions.

Control Properties: View and modify properties for the selected control.

View Code: View and modify the code for the selected control in the Visual Basic Editor.

To add objects in the worksheet, you can click the corresponding icon in the Developer tab. See below:

developer function

Figure 3 Add objects icons

You can add check box, text box, command button, option button, list box, combo box, toggle button, spin button, scroll bar, label, image, and more controls in the worksheet by the corresponding icon.

When the cursor turn into a cross, hold and drag it to insert the object in the worksheet. After the object was drawn, double click it to edit it in the Microsoft Visual Basic.