Unexpected Macro Run

[Onefynebarraza]

Hello,

I am running into a scenario where I don't intend the macro to run and i'm not sure how to make it stop.

The macro is only supposed to run if columns 5 and 6 are filled however, for some reason this macro is running whenever I make a change to another cell. I think it has to do with this line of code:

Please Login or Register  to view this content.

. However, I am having a hard time figuring out how to fix it. Please help! Thank you Excel Gurus!!!

Please Login or Register  to view this content.

[TMS]

Put Stop as the first line of code in the event handler. Then make a change in the worksheet and use F8 to step through the code. Check the contents of cells and variables to see what is happening.

[Onefynebarraza]

I put stop in like this

Please Login or Register  to view this content.

[/CODE]

and I pressed F8 to step through the code but I couldn't figure out what the problem was. Any suggestions?

[TMS]

And the password for the VBA project is … ?

[TMS]

Forget it … I guessed from the sheet password

[TMS]

Try this:

Please Login or Register  to view this content.

[TMS]

Notes:

1. You have a loop to UnProtect ALL the sheets at the beginning
2. You have a loop to Protect ALL the sheets BUT it is inside the main IF block so it might not get executed
3. By deleting a row within the Worksheet Change Event handler, you are making a change
4. You need to disable and re-enable event handling around the changes you make within the event handler