How do I stop a macros from running?

Hi,

I'm new to excel. Any help will be appreciated.

I have a worksheet with a cell (I3) that has a date in it. If that date is equal to today's current date then I want a macros called "MacrosI" to run only once. The problem is that it runs over and over again making Excel shut down and I cannot get it to stop. Below is the coding that I have come up with so far.

Please Login or Register  to view this content.

Thanks for any help.

Harrison.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. I have done it for you today, as you are new here.)

You need to test the actual cell being changed, which is the argument named Target. You are changing the Target to always be I3 whenever the worksheet changes.

Please Login or Register  to view this content.

Now it will run when you change the contents of I3