Advanced Controls Options
Enabling and Disabling Advanced Controls
To alert and protect users against potentially harmful code, Engineering Notebook issues a warning message every time you attempt to open a worksheet that contains advanced controls. If you open a worksheet containing advanced controls that you know to be safe, click Yes when the warning box is displayed. Clicking Yes enables all the controls in the worksheet. If you click No, the advanced controls are disabled and the script is not functional. In this case, you can still access the Script Editor tab to make changes to the script, but the Properties tab remains disabled. If you apply the changes, the script does not run.
If you initially choose No but want to enable the advanced controls later, follow these steps:
1. In the worksheet, select the controls you want to enable.
2. Right-click the control and select Enable Region. Alternatively, go to the Calculation tab and Select Disable Region.
If you want to hide the warning permanently, click 
> and select Hide Advanced Controls warning.
> and select Hide Advanced Controls warning.Configuring Advanced Controls Recalculation
By default, advanced controls scripts are not executed when opening or recalculating the worksheet. The scripts run when interacting with the control (e.g. changing a selection or clicking a button). To configure the events that trigger the execution of the scripts, click > and select Run the Advanced Controls scripts on worksheet open or Run the Advanced Controls scripts on worksheet recalculate. You can also enable both options, this may cause a performance decrease.
> and select Run the Advanced Controls scripts on worksheet open or Run the Advanced Controls scripts on worksheet recalculate. You can also enable both options, this may cause a performance decrease.Setting Python as a Scripting Environment for Advanced Controls
Advanced controls support VBScript, JScript and Python. Using VBScript and JScript does not require a setup because Engineering Notebook uses the software installed on your operating system. In contrast, using Python requires a setup.
When you use Python as a scripting environment for the first time, Engineering Notebook searches your computer for a supported version of Python. Engineering Notebook supports versions 3.7 through 3.13. If Python is not installed, the script editor is inactive and displays an error message.
Follow these steps to set up Python as a scripting environment. This process is also useful if you have several supported versions of Python installed on your computer, and you want to specify one of them. You can change your version selection later.
 | Restart Engineering Notebook after selecting a new Python version. |
1. Install a supported version of Python on your computer.
2. Go to > and check Set the path to the Python installation folder.
> and check Set the path to the Python installation folder.3. Click Browse. The Browse For Folder dialog box opens.
4. Browse to the location where Python is installed on your computer and select the repository.
5. Click OK. The path to the repository is added to the dialog box.
6. Click Close.