Macro stopped running

[matthewlouis]

When I open worksheet, there is a macro that is supposed to run. When I hit Alt F11, the box is grayed out with no code.

I don't code, just a formula guy, this was a macro someone here on the board helped me with. So I am dense on coding. But this is a great macro.

When I open the worksheet, I am not asked anything. I went to File>Info> and the Security Information is not restricting (I trust the source).

What happened to the macro and why is the box grayed out and no code is there?

Thanks in advance!

 

[Joe4]

OK, let me add that line.

Once added, again, do I close the sheet and reopen and that will run the macro?

Yes, save, close, and reopen.

That process does not change.

 

[matthewlouis]

OK

 

[matthewlouis]

Added, saved, closed, and opened, still isn't calculating like it was.

 

[Joe4]

Is it running though? Your original question was in regards to it not running.

If it is running, but not doing what it was before, then something changed - either the code or your data.
Since we have no idea what it looked like before, I don't know that there is much we can do for you.

You might be better off to start over from scratch and forget the code you have know, and clearly explain exactly what you want to happen, in detail.

 

[matthewlouis]

OK, I really appreciate your help. I didn't change anything, the code or the data. No idea what happened.