[rcobos]

Hi Guys:

I have created a macro( 2 line macro actually) that goes through my workbook and it supposed to clear the value from cells b1:b68 on main page. When I try to run the macro with the sheet protected I get a pop up that just says "400" in it with a red circle that has a white "X" through it, whit the sheet unprotected works perfectly !. Because it is a survey I need to protect teh content, to be manipulated by many. Can somebody give a clue? Here is the code:

Public Sub Clear()
Sheet1.Cells.Range("B17:B68").ClearContents
End Sub


Windows 7
MExcel 2010

Many thanks

Rod

[Rollin_Again]

So just add a couple of lines of code to first unprotect the sheet, then clear the contents, the protect the sheet again.

Rollin

[ssye894]

[rcobos]

Thank you very much.......I tried it but when you run the macro, it ask you to input the password to unprotected the sheet, then i have to give everybody the password....... there is no point to protect it............ so back to square one..

[GeorgeJ]

Could you not make the VBA unlock the sheet by providing the password
do what you want
then lock the sheet again using the password

Then the user wouldn't know the password if the macro was locked too, possibly ThisWorkbook.Protect Password:="yourpassword"

[rcobos]

Thank you very much for your help, worked like a charm !!!

Thank for your time !

Rod

[Rollin_Again]

Keep in mind that if the macro code is attached to the workbook you are sending out others will be able to view the code and retrieve the password unless you password protect the code module.

Rollin