| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear option buttons **MACRO TWEAK**
Hello, I have the current macro assigned to clear the contents of
unlocked cells. What I would like to do is also include the clearing of 2 Option Buttons as well. Thanks for your assistance! Private Sub CommandButton1_Click() Dim cell As Range For Each cell In ActiveSheet.UsedRange If cell.Locked = False Then cell.MergeArea.ClearContents Next End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRUE/FALSE MACRO using Option Buttons | Excel Discussion (Misc queries) | |||
| Option Buttons with macro and working with 2 workbooks | Excel Programming | |||
| Option buttons: How to get the selected option from a group? | Excel Programming | |||
| Can someone please tweak my Macro? | Excel Discussion (Misc queries) | |||
| No control for option buttons, invisible macro?? | Excel Programming | |||
Threaded Mode
