For double Loop with Rows & Locked Cells

Hello!

I am trying to make a loop that cycles through a specific range of cells if the contents of one cell contains "Y"

Basically:

All Cells are not locked
All Cells look normal
Cells within the range of C4:Q4 are locked and greyed out
If B4 = "Y" then C4 becomes unlocked, B4 & B3 changes color (light green fill dark green text), C4 Returns to the default color,
otherwise it remains locked
If C4 = "Y" then D4 becomes unlocked, C4 & C3 changes color (light green fill dark green text), C4 Returns to the default color,
otherwise it remains locked

This continues as a loop until it reaches the end.
It would keep doing this check every time I enter something in the unlocked box.

i have some code I wrote from a lot of googling and a rusty knowledge of a cs course from university.

Please Login or Register  to view this content.

Also I'm on a MAC smh :\ if that makes a difference.

I need some help, I have a VERY general understanding of VBA, but not the right kind of knowledge to get exactly where I need to go.

Any suggestions?

Not sure how the code changes on a MAC, but in general:

Locking/unlocking has no effect unless the sheet is Protected. So, in your code, if you want to change the locked/unlocked status you need to Unprotect the worksheet at the front end.

If before protecting the first time you've set the cell properties to Unlocked for everything except C4:Q4, then you don't need to change the locked/unlocked status of anything, just first unprotect the sheet, apply your changes, then reprotect the sheet. http://analysistabs.com/excel-vba/pr...ct-worksheets/

I'm assuming you're going to have a user who's going to input a value in B4, which, if it's Y, triggers everything to happen. If so, that's a Worksheet Change Event, which goes into the specific Worksheet object module, not a standard code module. B4 will be the trigger.http://www.excel-easy.com/vba/events.html

trying to compile, but getting an error:

Member already exists in an object module from which this object module derives.


Any suggestions?

From a Microsoft Help file:

Please Login or Register  to view this content.