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!

 

[matthewlouis]

When I follow instructions after Alt F11, hit Ctrl-S, and then Alt-Q, etc... it isn't starting the macro.

 

[Joe4]

Yes, I see VBA code when I hit ALT F11

But WHERE???
As I said, which module it is in is key here.

Go back and read what I wrote in my last post more carefully.
You want to specifically check the ThisWorkbook and appropriate Sheet modules for code.
They will probably NOT be the ones you first see when you hit ALT+F11, so you will probably need to click on them to inspect them.

If you have trouble following along, take some time to read the link I gave you.

 

[matthewlouis]

See picture

 

[matthewlouis]

Ah, OK, let me see.

 

[matthewlouis]

I'm sorry, I do not see ThisWorkbook
As I said, I am WEAK when it comes to coding

 

[Joe4]

I'm sorry, I do not see ThisWorkbook
As I said, I am WEAK when it comes to coding

Scroll up in your VBA Project Explorer. Every workbook has one:

When you find it, double-click on it, and check for any VBA code.
Do the same for the Sheet module of the sheet that has the data this is running against (check for VBA code in that particular module).

 

[matthewlouis]

OK, see attached, this is what I see.

 

[Joe4]

Please double-click on "ThisWorkbook". A new VBA code window should pop-up showing you the code in that module.
The window you are showing is for "Module2", not "ThisWorkbook".

 

[matthewlouis]

Ahh, there is no code in there when I click on ThisWorkbook.

 

[matthewlouis]

So I copied and pasted code into ThisWorkbook. Now what?