| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling shapes and controls
Oops
Must be ActiveSheet.DrawingObjects.Enabled = False -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Jonathan Try this On Error Resume Next ActiveSheet.DrawingObjects.Visible = True ActiveSheet.DrawingObjects.Enabled = True On Error GoTo 0 See also http://www.rondebruin.nl/controlsobjectsworksheet.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan Orgel" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
| Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
| When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
| How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
| How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
