Excel Marco Keep on Looping

[Legacy 185509]

Hi
I have Macro that runs automatically when file is open
but I want to run once only but this code is repeating itself again again intead of running just once
please help
thank you

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.OnTime Now + TimeValue("00:00:15"), "Mail_Selection"
'Application.OnTime TimeValue("08:52:00"), "Mail_Selection"
End Sub

second line is commented out, I am using windows task schedule to open the file and stuff

 

[Trevor G]

In the workbook Events select Open then call your macro by its name. Open the workbook use Alt + F11 then double click thisworkbook on the left in the Project Window, at the top select the Object down arrow and select Workbook this should the give you the Open Event on the right.

Private Sub Workbook_Open()
Call Mail_Selection
End Sub

You then need to comment out the other code.

 

[Legacy 185509]

In the workbook Events select Open then call your macro by its name. Open the workbook use Alt + F11 then double click thisworkbook on the left in the Project Window, at the top select the Object down arrow and select Workbook this should the give you the Open Event on the right.



You then need to comment out the other code.

Hey
After Changing from General to Worksheet
it put this code there automactically

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub

 

[Legacy 185509]

see this works but it would call the method everytime I click anywhere on the worksheet

 

[Trevor G]

No not the worksheet but workbook Events....

You will have to comment out the Worksheet Event and look at the instructions I suggested for the Workbook Event.

 

[Legacy 185509]

I did follow what you told me
herei s the screenshot of my VBA Editor

sorry I dont know if I am right, is the the one under sheet9 ?

 

[Trevor G]

Did you double click the item that says thisWorkbook, below sheet 9, your screen shot indicates that it is still one of the other sheets.

 

[Legacy 185509]

Thanx alot it worked like charm
I was getting tensed that I don't have what you asked me to look for lol
thanx again

 

[Trevor G]

Glad you got it working.