How do I disable/lock all controls and shapes on a worksheet. Or if you how
do I disable a specific checkbor or textbox.

I tried the code below but this just 'disables' the buttons. Checkboxes and
textboxes can still be changed.

For Each S In Sheet.Shapes
S.OnAction = ""
S.Locked = True
Next
For Each V In Sheet.OLEObjects
V.Enabled = False
Next


Thanks,

Jonathan Orgel