Hitachi

JP1 Version 12 JP1/Automatic Job Management System 3 - Definition Assistant Description, Operator's Guide and Reference


3.1.3 Enabling Excel macros (checking security level)

Excel macros are used for JP1/AJS3 - Definition Assistant functions.

When you use the product with Excel, perform either of the following methods to enable Excel macros.

Organization of this subsection

(1) Setting Excel macros by selecting Enable Content

In Excel, Trust Center>Macro Settings>Disable all macros with notification is selected by default. When you open the definition information management template in this state, the message Security Warnings Macros have been disabled. is displayed in the message bar. To proceed, click the Enable Content button.

Supplementary notes:

If you select Trust Center>Macro Settings>Enable all macros (not recommended; potentially dangerous code can run), you can also use all the functions in the definition information management template. Note, however, that this method enables macros for Excel files other than the definition information management template as well.

In addition, if you select Disable all macros without notification or Disable all macros except digitally signed macros, you will not be able to use some of the functions in the definition information management template.

(2) Setting Excel macros by selecting Trust Center and then Trusted Locations

Use the following procedure to add the file storage folder for the definition information management template used for import or export to Trust Center>Trusted Locations before starting operation.

  1. Start Excel.

  2. Select the File tab and then click Options.

    The Excel Options dialog box appears.

  3. Select Trust Center in the area on the left, and then click the Trust Center Settings button in the area on the right.

    The Trust Center dialog box appears.

  4. Select Trusted Locations in the area on the left, and then click the Add new location button in the area on the right.

    The Microsoft Office Trusted Location dialog box appears.

  5. Enter the path to the file storage folder for the definition information management template for import or export in Path. Alternatively, click the Browse button to specify the file storage folder for the definition information management template for import or export.

  6. Select Subfolders of this location are also trusted, and then click the OK button.

  7. Make sure that the path to the folder specified in step 5 has been added to Trusted Locations in the area on the left of the Trust Center dialog box.

    If there are multiple file storage folders for definition information management templates for import or export, repeat steps 4 to 6 for each folder.