shortymcshort
New Member
- Joined
- May 26, 2006
- Messages
- 15
Sub Worksheet_Calculate()
If Range("Ak6").value = 2 Or Range("ak6").value = 20 Then
Application.Run "Enter"
End If
End Sub
I have this workshet_calcualte() macro that I am using and it works fine as long as I have this workbook open. I can minimize it and work on other stuff and this macro will still kick butt. But whenever I am in another completely excel file this macro won't work. I assume that is because it can't find the sheet that it is supposed to work in.
My question is: Is it possible to have this macro run while I am working in another excel file. Version 2003 The name of the file with the macro in it is called "twsdde.xls".
Everytime I put in object.GetFile(C:\Jts\Excel\TwsDde.xls) it immediately pops up a complie error syntax error and I can't figure out what it is. I am putting it above the if statement.
thanks
Eric
If Range("Ak6").value = 2 Or Range("ak6").value = 20 Then
Application.Run "Enter"
End If
End Sub
I have this workshet_calcualte() macro that I am using and it works fine as long as I have this workbook open. I can minimize it and work on other stuff and this macro will still kick butt. But whenever I am in another completely excel file this macro won't work. I assume that is because it can't find the sheet that it is supposed to work in.
My question is: Is it possible to have this macro run while I am working in another excel file. Version 2003 The name of the file with the macro in it is called "twsdde.xls".
Everytime I put in object.GetFile(C:\Jts\Excel\TwsDde.xls) it immediately pops up a complie error syntax error and I can't figure out what it is. I am putting it above the if statement.
thanks
Eric