Archive of Mr Excel Message Board
Back to Errors in Excel archive index
Back to archive home
run-time error '1004'Posted by Frank G on September 17, 2001 4:19 AM
I am getting the following error:
run-time error '1004'
Unable to get the CheckBoxes property of the Workhseet class
Re: run-time error '1004'Posted by Juan Pablo on September 17, 2001 8:57 AM
Are this checkboxes in a user form ? what i mean is Whic toolbar did you use to insert the checkboxes ?
If it was the VB toolbar then use MSForms.Checkbox
I think that'll take care of the error. If not then please explain some more what you're doing / trying to do.
Re: run-time error '1004'Posted by frank on September 20, 2001 3:33 AM
I am using the checkbook from the Form toolbar.
I have multiple sheets that I want to protect.
I am using Excel 97 SR-2.
Here is the macro I am trying to use for one sheet.
' Toggles sheet protection
If Sheets("Sun_Scores").CheckBoxes("cbProtectSheet").Value = xlOn Then
ActiveSheet.Protect DrawingObjects:=True, Contents:=True
I get the run-time error message and the line with
the x1On is highlighted in yellow in the debugger.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.