Worksheet_Change not working

[BML1]

I have 3 option buttons that populate cell K5 with "ELEV2", "STA2" OR "GRADE"

Cells D8, D10, D12, H8 and H10 are user input that will constantly be changed by user

I need help getting it to auto update when the user changes any of D8, D10, D12, H8 or H10.

Also I would like to lock H10 in the Case of ELEV2, but when I insert Range("H10").Locked = True , i get an error
Any help would be great, I am a beginner!! (Excel 2007)

Please Login or Register  to view this content.

[JBeaucaire]

Well, you could dispense with the locking/unlocking and put this line of code at the top:

Please Login or Register  to view this content.

Even if the sheet is already password protected, this sets the flag that allows macros to run freely on the locked sheet. It doesn't unprotect the sheet from the user's point of view.

So, there's no need to "reprotect" later because you never removed the protection. See if you get better results with this.

If not, this is still a technique worth adopting.

========
Also, you're on Excel 2007, which means your sheets can easily outstrip the limitations of the "Integer" variable declaration. Go ahead and switch to "Long" for all those declarations to keep from ever running into issues with that.