VBA script not running with blocked cells (not the ones the vba script is using)

Hi,

so I'm running a vba script which should change the color of a cell after the user has been modifying the sheet.
The cells the script is coloring in is not protected, but other cells in the same row. (7+)

Without protection the script is running fine, with I'm running into an error (request to debug).
I have no clue why.

Please Login or Register  to view this content.

I can and will provide any necessary data anybody needs to solve this puzzle.
Hope somebody can help me,
Edward

Originally Posted by davesexcel

Unprotect the sheet at the beginning of your code, then protect it again at the end of the code.

Changed it to

Please Login or Register  to view this content.

, but still getting the same error.

Attachment 814919

Originally Posted by davesexcel

Where are you unprotecting the sheet?

Search for "excel vba unprotect sheet"

I thought it was:

Please Login or Register  to view this content.

But after using your searchterm I found this:

Please Login or Register  to view this content.

Do I need only the 2nd one, or both?

Originally Posted by rorya

Did you select the option to allow formatting cells when protecting the sheet?

How do I do that? I'm quite a noob with vba and just clobbering this together.

Originally Posted by rorya

Did you protect the sheet in code originally? If not, just check that option when protecting the sheet in the UI. If you did do it in code, it's like this:

Please Login or Register  to view this content.

I did it using the GUI.
Might that be the problem? Problem is, I need only to protect some cells, so nobody is overwriting the formulas.

Originally Posted by rorya

When you protect the sheet in the UI, one of the options you can set is to allow formatting cells. Then your code should just work as is.

And that was the fast solution
Thank you very much.

Originally Posted by davesexcel

Just the one to unprotect the sheet

Will keep that in mind.
How do I protect the VBA code if the password is in there in plain text?