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.
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.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
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??
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.
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 .
Here is a basic example.
Works just fine...
Hmmm... I'll play around with my settings and see if I can find anything there. Thanks for trying though
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 -
Then try again and see if the worksheet change event works on selecting months from dropdown.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks