Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have placed several check boxes on a spread sheet using the Forms toolbar.
The spread sheet is read only and protected. The check boxes can still be selected and moved or deleted. How can this be prevented? Below is the macro that I am using: Private Sub Button1_Click() Range("G1,L9,I13,I14,I15,L22,L34,J36,J38,K44,K45,K 46,K47,K58,L75,L79,K82,L99").Select Selection.ClearContents Range("l9").Select Dim cb As CheckBox For Each cb In ActiveSheet.CheckBoxes cb.Value = False Next cb End Sub The spread sheet will also be used on Excel 97. Any assistance would be appreciated. -- dow |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft Excel 2003 - Help with Catalog set up / Check out | Excel Worksheet Functions | |||
How do I add check boxes in Excel 2003? | Excel Discussion (Misc queries) | |||
Copy and paste problem Excel 2003 to Word 2003 | Excel Discussion (Misc queries) | |||
How can I add a medical spell check to excel 2003? | New Users to Excel | |||
Excel 2003 Spell Check | Excel Discussion (Misc queries) |