Versions Compared

Key

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

...

The OnEditAttempt event fires when the user attempts to edit a cell whose CellProtection is set to "Selectable". This give you the opportunity to notify the user as to why he/she cannot edit the cell. The reason this event only applies to "Selectable" cells is that users are allowed to enter into edit mode for "Read Only" cells and can never even select "Full" protected cells.

...

Code Block
Transfer Param1 to Cell 
Transfer Param2 to Count 
Transfer Param3 to Text 

// If the user is attempting to edit for the first time, 
// let them know that they can't (by using a spiffy 
// balloon tooltip) 
If Count EQ 1 then 
   Config = "" 
   Config<1> = "This cell cannot be edited."   ;// Message 
   Config<2> = "Cell Protected"                ;// Title 
   Config<3> = 3                               ;// "Stop" icon 
   Config<4> = 4000                            ;// 4 second timer 
   Convert ';' to @FM in Cell 
   rv = Send_Message(@Window:".OLE_EDITTABLE", "OLE.ShowBalloonTooltip"

See Also

CellProtection