Code works in the Module1 but not in the Worksheet?

[HerryMarkowitz]

Greetings,
1- Open enclosed file named HerryMarkowitz1.
2- Click A1 cell. (When you click A1 cell you will see that everything is okey)
3- Close the file named HerryMarkowitz1.

4- Open enclosed file named HerryMarkowitz2.
5- Click A1 cell. (When you click A1 cell you will see that nothing is okey)

The question is;
Why does code work in the Module1 but not in the Worksheet?

[Mumps1]

Move this macro:

Sub Macro1()
MsgBox "Hello"
End Sub

from the worksheet code module into a regular module.

[HerryMarkowitz]

Move this macro:

Sub Macro1()
MsgBox "Hello"
End Sub

from the worksheet code module into a regular module.

I know that...
My question is why does code work in the Module1 but not in the Worksheet? I want the code can work in the Worksheet...

[Mumps1]

Check out this link. It might explain the reason. http://www.ozgrid.com/forum/showthread.php?t=87159

[JOHN H. DAVIS]

Does this help?

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [A1]) Is Nothing Then MsgBox "Hello"
End Sub

[HerryMarkowitz]

Does this help?

Hi John
It doesnt help...
Because my question is regarding how to run other SubRoutine in the WorkSheet Module...

[JOHN H. DAVIS]

You can call it.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [A1]) Is Nothing Then Call MacroOtherSubRoutine
End Sub

Will call your macro upon changes made to A1.

[HerryMarkowitz]

I have put following codes into Sheet1 code module but my problem havent been solved yet...

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [A1]) Is Nothing Then Call Macro1
End Sub
Sub Macro1()
MsgBox "Hello"
End Sub

[Norie]

Macro1 shouldn't really be in a worksheet(or workbook) module.

The only code that should be in such a module should be code that is associated with the worksheet/workbook.

For example code for a SelectionChange/Change event.

[HerryMarkowitz]

Macro1 shouldn't really be in a worksheet(or workbook) module.
The only code that should be in such a module should be code that is associated with the worksheet/workbook.
For example code for a SelectionChange/Change event.

Hi Norie,
I am really confused...
Please put following code into Sheet1 code module then see working code properly...

Private Sub Worksheet_Activate()
Call Macro1
End Sub
Sub Macro1()
MsgBox "Hello"
End Sub