WksProperties-Dialog-Script-Tab
To open the Script tab of Worksheet Properties dialog:
or
The LabTalk script that is entered in the script box is associated with the active worksheet. The method of script execution is controlled within the tab. Save the worksheet as a template and the associated worksheet script is saved as well.
Select this check box to execute the worksheet script each time you import data into the worksheet.
Select this check box to run the script in the Script Box whenever a change is made in the dataset specified in the associated text box. Following dataset range notations are supported in the associated text box. Note that both space and comma are supported here as separator(s).
A,C,E // Column A, Column C and Column E A C E // Column A, Column C and Column E A:E // Column A to Column E A:B, D:E // Column A to Column B and Column D to Column E A:B D:E // Column A to Column B and Column D to Column E 1:end // All Columns 1:2, 4:end // All Columns except the third column 1:2 4:end // All Columns except the third column
Select this check box to execute a single statement script in the Script Box without ending with a semicolon.
Type the desired LabTalk script in this text box. The script should follow the same syntax conventions as a LabTalk script file. For more information, see the LabTalk Section of the Programming Help file (Help:Programming).
Click Run button to execute the script immediately. Additionally, clicking , or button will save the script and execution method to the worksheet and set them as the default settings.