Command Button returning runtime error 1004

[Guest]

I have developed a workbook which contains multiple worksheets. Within each
worksheet I have added security with the exception to certain cells. To do
this I selected the cells and within security I unchecked the "locked" box; I
then protected the sheet.
On one page I have a command button that is coded to clear all of those
unlocked cells. An example of the code would be as follows:
Worksheets("Book").Range("C4:C10,C12:C13,C16").ClearContents
Each individual sheet contains this same range code within a command button.
My Problem is that the command button on my Table of Contents page with the
above code gives me a runtime error #1004.
Can someone help me keep the security in place but allow this button to run...
Thank you so much for your help in Advance...
Ed Prill

 

[Frank Stone]

hi,
See your other post
regards
Frank

-----Original Message-----
I have developed a workbook which contains multiple worksheets. Within each
worksheet I have added security with the exception to certain cells. To do
this I selected the cells and within security I unchecked the "locked" box; I
then protected the sheet.
On one page I have a command button that is coded to clear all of those
unlocked cells. An example of the code would be as follows:
("C4:C10,C12:C13,C16").ClearContents
Each individual sheet contains this same range code within a command button.
My Problem is that the command button on my Table of Contents page with the
above code gives me a runtime error #1004.
Can someone help me keep the security in place but allow this button to run...
Thank you so much for your help in Advance...
Ed Prill
.