Worksheet_change will not run automatically

I cannot get either worksheet_change or worksheet_calculate to fire upon a change in a worksheet. I haven't found the answer on any forum. I created a dummy file to fire a goal seek automatically (also tried firing a simple msgbox, which didn't work either).

My settings are:

- Enable all macros
- Trust access to the VBA project object model

I inserted the code with a right click on the worksheet I was in, so I think it's in the right place. Also, my goal seek runs correctly if I click F5 in the code. I just can't get this to run on a worksheet change.

I'm new to VBA, though I'm pretty sophisticated with Excel otherwise. Any help would be greatly appreciated. My code is as follows:

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

It's possible that Enable Events is false, try

Please Login or Register  to view this content.

. You can place this under your Worksheet change procedure and then run it. After you do that try running your code in the change event again. If it still doesn't work, try

Please Login or Register  to view this content.

On your next post, click "Go Advanced" and then look for the paperclip icon and follow the prompts.

It was as I thought, you placed the worksheet change procedure in a standard module when it needs to be placed in a worksheet module. In the vbe of the uploaded workbook (from me), double click Sheet1 under "Microsoft Excel Objects" and you'll see the code there and working.

Originally Posted by barryleajo

Works for me as posted!
Are you changing the value in C8, otherwise it already has the answer in C4?

I can't see how it could have worked as posted if the Worksheet change event wasn't placed in the worksheet module. Just sayin!