run time error 1004, cell or chart is protected.

I get run time error 1004 when I click on a cell in a worksheet Attachment 154599
The shhet is not protected nor is the cell locked so don't understand why I get this error. When I click on debug then the following comes up The line marked with[*] is highlighted yellow

Please Login or Register  to view this content.

Anyone have a solution or suggestion.

Thanks

dude, cost summary is protected in the attachment. Find the password for that and unprotect it in the VBA

worksheets("Cost Summary").unprotect ("passwor here")
YOUR CODE HERE, then reprotect if needed.
worksheets("Cost Summary").protect("password here")

Ok. Glad you mentioned that. I have 2 answers related to this:

1) If you only plan to have the macro access certain areas of the sheet, you can allow those ranges to be edited. This is likely what you need.

To set up allowed ranges on a protected sheet:

Review tab>Allow Users to Edit Ranges
Basically you name the range, and select the allowed cells from the sheet (if you have trouble doing this see the attachment).

Then you protect the sheet and give it a password.


2) If a macro needs to adjust a protected cell/range (anything that you have NOT told the spreadsheet is allowed for editing) THEN:

You must unprotect the sheet before running the macro. The easiest way to do that is with the code, because then the user doesn't have to be aware of the password (because they could then just do whatever they want which defeats the whole idea) AND you get the protection. Usually i'll do this -- this works no matter how the sheet was protected (either "by hand" or "by Macro")

Worksheets("sheet name here").unprotect password:="password here" OR FOR SHORT JUST Wrksheets("sheet name here").unprotect("password here")

IF you then want to reprotect the sheet after the macro makes the changes, you can add this line:

Worksheets("sheet name here").protect password:="password here" (there are other parameters you can set other than just a password...you can look at the help menu for this method to learn more).

General Structure for approach 2:

Please Login or Register  to view this content.

hmm...i don't know exactly what you ran, maybe you can post the workbook? what i meant to indicate was the password should go in the code.

@ General Disarray...........the file is in your reply above (Steve Unprotected(2).

I understand how to do Method 1 and so this is how I have done the attached file, however in this attached one the sheets are not protected. The orange cells through-out the workbook are the ones that should be allowed for user entry.
When I then protect the Cost Summary page I then get runtime errors on first sheet (Main Data) when I click in the orange fields that I need to enter data into. The fields on Main data have to be filled in as this is what denotes what values come from elsewhere in the document and popuplate values on the Costings sheet.

If you password protect please use 1234 as password

Thanks for your assistance and understanding

ok, not sure if this is what you are after or not (attached).

Are you using the one i attached on my last post or some other sheet? I don't have that error happening on what i've just returned.

The only thing you might be missing is, you need to include the uprotect line in your macro (with the proper password "1234") OR you just need to "allow users to edit" any cell being changed by the macro. BUT in what i've just attached it looks like you will need to unprotect/protect the sheet because you have not allowed the users to edit cell p13.

Proper unprotect/protect lines look something like: (This was the macro included in the main Data code module on the last attachment i returned to you).

Please Login or Register  to view this content.

---------
NOTE: i am not having the problem you describe on the sheet i just attached on my last post.