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!

 

[JoeMo]

You might improve your chances of getting an answer if you post the code (macro) you reference.

 

[matthewlouis]

Sub clicky()
For t = 1 To 100
Application.Calculate
Range("J10").Value = Range("J10").Value + 1
If Range("k2").Value <= 0.8 Then Range("J12").Value = Range("J12").Value + 1
Debug.Print t & ":" & Range("k2")
MsgBox t
Next t
End Sub


THIS is highlighted in yellow (like there is an error) . . . If Range("k2").Value <= 0.8

 

[matthewlouis]

It runs 100 tests to see how many passed and how many failed.

 

[JoeMo]

Sub clicky()
For t = 1 To 100
Application.Calculate
Range("J10").Value = Range("J10").Value + 1
If Range("k2").Value <= 0.8 Then Range("J12").Value = Range("J12").Value + 1
Debug.Print t & ":" & Range("k2")
MsgBox t
Next t
End Sub


THIS is highlighted in yellow (like there is an error) . . . If Range("k2").Value <= 0.8

The code you posted won't run by itself when you activate the worksheet. Is there a button you click to run the macro .... or is there a worksheet_activate event code in the sheet?

 

[matthewlouis]

Well, I just copied and pasted the macro that was in the code. Whenever I opened worksheet, it would run. It isn't now. I have no idea why it stopped.

 

[Joe4]

Well, I just copied and pasted the macro that was in the code. Whenever I opened worksheet, it would run. It isn't now. I have no idea why it stopped.

Do you mean "opened the workbook" or "go to a specific worksheet"?
(That nomenclature is critical here, as VBA code can run automatically when a workbook is first opened and/or when a worksheet is first activated).

If you go into your VB Editor, do you see any VBA code in the "ThisWorkbook" module?
How about any VBA code in the particular sheet module that your data resides in?

This link shows you where you can see those VBA modules: What is a VBA Module? - Automate Excel

 

[matthewlouis]

Opened the workbook.

Let me look.

 

[matthewlouis]

Yes, I see VBA code when I hit ALT F11

 

[matthewlouis]

Sub clicky()
For t = 1 To 100
Application.Calculate
Range("J10").Value = Range("J10").Value + 1
If Range("F11").Value <= 0.8 Then Range("J12").Value = Range("J12").Value + 1
Debug.Print t & ":" & Range("F11")
MsgBox t
Next t
End Sub
									100​
ALT + F11
Ctrl-S									100​
Let it run
Alt-Q
Alt-F8
Hit Run
Alt-G opens up Immediate Box
To Calculate, hit CTR-SHIFT-C then ESC