link broke

[RobcPettit]

Hi, I hope this makes sense. I have live data fed into sheet1. I have
code in Worksheet-change. When the cide fires I use
Application.enableEvents = false - do my calcs - then reset Events to
true. My data starts at range("a8"), results of calcs are displayed in
range("a4"). Today it started ok, link was working fine. Until, I
decided I wanted my data to start at range("a2"). So, before
connecting the live data, I deleted the existing data, saved the
workbook then connected the live data. The connection doesnt work now.
Ive tried reinstalling excel, the program that collects the dat etc.
Is there away to check that I ve enabled events propely.
Regards Robert

 

[Susan]

any new computer hardware installed? i had this problem recently &
finally discovered that with a new computer, the computer guy had
changed my link to the server from "c" to "z".
susan

 

[Guest]

Sub TurnOnEvents()
Application.EnableEvents = True
End Sub

will turn on events. If you just want to know if they are enabled

Sub QueryEventStatus()
Msgbox "Events on? " & Application.EnableEvents
End sub

 

[RobcPettit]

Thankyou both for your replys. No changes to the computor at all. Ran
the QueryEvents and showing as true. Just to add, this is the second
time Ive had this problem. The first was on monday and the only way I
resolved it was to do a non destructive re install of xp, which Im
trying to avoid this time as it took ages. This has got me thinking as
to wether Ive altered a registry setting.
Regards Robert

 

[RobcPettit]

Hi, Is it possible that reg values could have been altered?

 

[Tom Ogilvy]

I doubt that is the problem, but reregistering is easy to do

http://support.microsoft.com/kb/291288/en-us

look at the /regserver switch.

You can execute it in the run box of the Start menu.