Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Warning

After you install Option B, you must change the macro security setting in Excel.  If you do not change the security setting and enable macros, many of the features in the spreadsheets will not function correctly.  Depending on your macro security setting and version of Excel, Excel may ask if you want to enable Macros when you open these forms.  ALWAYS  enable macros when using this software.

If Macros have not been enabled, the spreadsheets should show a prominent warning in the header area. (Note: the “Macros Disabled” warning may be briefly visible when you open a form and while you are saving a form; this is normal.) 

The instructions for enabling macros are also available from the Help menu (Macro Security Setting item) on the Registration form.

Warning
titleImportant Note for Excel 2010 Users

When an Option B workbook is opened, a macro runs that reads some identity information from the Registration form and hides the red “Macros are disabled” warning in the header area of the spreadsheet. In Excel 2010 only (not in earlier versions of Excel), this macro runs only if Excel is already running when you open the workbook.

Therefore for Excel 2010, we strongly recommend that you start Excel 2010 before opening an Option B workbook.

 

If you need further assistance, contact the Pesticide Reporting Service Bureau.

...

Warning
titleIMPORTANT

The Excel eForms rely on the use of VBA Macros. ALWAYS enable macros when using this software.

...

The identity fields in the header area of each form are filled with the values you entered on the Registration form.  Changing the identity fields here does not update the corresponding fields on the Registration form.  While the certification number and applicator name are editable, there are better methods for reporting for multiple applicators.  The commercial permit number field is editable so that you can report for multiple commercial permittees  in one report submission. 

...