There are 2 events at least people need to capture in TM1 frontends:
1) Stop the delete key so people don't delete the DBRW formula
2) Stop an F9 and instead do a shift plus f9
The code below in the workbook events module will help with this.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "{DELETE}"
Application.OnKey "{F9}"
End Sub
Private Sub Workbook_Open()
Application.OnKey "{DELETE}", "delKey"
Application.OnKey "{F9}", "+{F9}"
End Sub
Sub delKey()
MsgBox "The delete key has been disabled. Please use the space bar instead", vbExclamation
End Sub
