| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling shapes and controls
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 |
| 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) | |||
Threaded Mode
