Customizing code

Caution must be exercised when customizing the code by inserting Control toolbar objects into a worksheet or by using Visual Basic Editor.

These issues are resolved by saving and reopening a workbook:

• Using the Design Mode command on the Control toolbar, the #VALUE! is displayed in all MPCData cells on the worksheet. To prevent this issue, use the Data Validation toolbar or the Forms toolbar.
• If custom code throws an unhandled exception, #VALUE! is displayed in all MPCData cells on the worksheet. Errors are handled using On Error Resume Next or On Error Goto.