Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unchecking check boxes on exit
I assume there must be a way of unchecking all checkboxes on exit but I can't find it. VBA code? Anyone know? Thanks -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=512179 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unchecking check boxes on exit
I'd uncheck them the next time the workbook opens. It makes life easier.
Where are the checkboxes (on a single worksheet?) How were they created (from the Forms toolbar or the control toolbox toolbar) Option Explicit Sub auto_open() Dim wks As Worksheet Dim OLEObj As OLEObject Set wks = Worksheets("sheet1") If wks.CheckBoxes.Count 0 Then wks.CheckBoxes.Value = xlOff End If For Each OLEObj In wks.OLEObjects If TypeOf OLEObj.Object Is MSForms.CheckBox Then OLEObj.Object.Value = False End If Next OLEObj End Sub Brisbane Rob wrote: I assume there must be a way of unchecking all checkboxes on exit but I can't find it. VBA code? Anyone know? Thanks -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=512179 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unchecking check boxes on exit
Thanks very much apprecited -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=512179 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering by Check Boxes | Excel Discussion (Misc queries) | |||
Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
check boxes - copy | Excel Discussion (Misc queries) | |||
Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) | |||
count check boxes | Excel Worksheet Functions |