Worksheet change macro no longer working

[burny888]

I have the following worksheet change macro in a rota I use,that will scroll to the month selected from a drop down box, it was working fine and all of a sudden today it stopped working, I have checked and its still referencing the correct cells. Also I have checked my macro security settings and there's no change there either. If anybody could help and let me know what could be causing this I would really appreciate it.

Please Login or Register  to view this content.

[sourabhg98]

I thin you must have inserted this macro in the module.
If yes then you are going wrong.

You need to right click on the target sheet >> view code and paste the above macro there not in the module.

[grimes0332]

There is nothing wrong with the code, however "Stopped working" means nothing really. What is not happening? Does the code execute? Does it not find anything??

[burny888]

Sorry I wasn't clear, I get no error messages, just when I use the drop down box to select a month it no longer scrolls to the matching month in column B. I have inserted this into the target sheet and not into a module. It was working fine yesterday but today I no longer does anything and I have made no changes to the macro. The only change I have made to the workbook is a Workbook Open Macro that scrolls to todays date found in column A when the workbook is opened. I don't think that would cause the problem and I have tried removing it just in case and there was no change.

[sourabhg98]

It is working fine for us.
Can you attach a sample file?
You can do so by clicking on Go Advanced button at the bottom of the post and then selecting the paper clip icon .

[burny888]

Here is a basic example.

[grimes0332]

Works just fine...

[burny888]

Hmmm... I'll play around with my settings and see if I can find anything there. Thanks for trying though

[sourabhg98]

Hey, I don't know for sure whats happening but you can give a try to this-

Put this macro in any module and run it by pressing F5 -

Please Login or Register  to view this content.

Then try again and see if the worksheet change event works on selecting months from dropdown.