ActiveX

To turn edit mode on and off using code

At run time,

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Set the EditMode property as follows:
   • If you want to turn edit mode off, set the property to False.
   • If you want to turn edit mode on, set the property to True.