usman5594
07-25-2013, 12:21 AM
Hi
i Need Help About Clear All Checkbox on my Sheet " Sheet2"
i use this code
Sub Clear_Check()
ActiveSheet.CheckBoxes.Value = False
End Sub
its work grate but when i protect the Sheet its give a error "1004"
And Can This Macro Run Automatically When Sheet2 is Activate
Kindly help
http://www.excelforum.com/excel-programming-vba-macros/941985-uncheck-chckbox-in-protected-sheet.html
i Need Help About Clear All Checkbox on my Sheet " Sheet2"
i use this code
Sub Clear_Check()
ActiveSheet.CheckBoxes.Value = False
End Sub
its work grate but when i protect the Sheet its give a error "1004"
And Can This Macro Run Automatically When Sheet2 is Activate
Kindly help
http://www.excelforum.com/excel-programming-vba-macros/941985-uncheck-chckbox-in-protected-sheet.html