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

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

On Jan 31, 5:44 am, "RobcPettit" wrote:
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

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

--
Regards,
Tom Ogilvy


"RobcPettit" wrote:

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

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

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

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.


--
Regards,
Tom Ogilvy


"RobcPettit" wrote in message
ps.com...
Hi, Is it possible that reg values could have been altered?