Use Registry Editor to disable (and enable) Virus Protection in Excel

[KyleS]

I know Word has the ability to diable the Macro Virus warning through VBA. But to the best of my knowledge to do this in Excel I need to go through the Registry Editor. I haven't used the editor before and was hoping someone could give me an idea of how to do this. I have an Access Report I'm running with a bunch of OLE objects in it and they all link to different Excel sheets, so the user gets a warning for each individual sheet (looks very amatureish). I want to disable the Virus warning when running the report and re-enable it after the report has finished.

Thanks in advance

Kyle

 

[Hasit]

There should be a "1" set under OPTIONS in the registry (click START->RUN, then REGEDIT) at the place below:

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Options


Set it to "0" which *should* resolve your problem

 

[KyleS]

Thanks for your response

Actually it's "Options6" that I change in the Registry.

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel\Options6

From 0x00000000 (OFF) to 0x00000008 (ON), but can I do this through code? I can't do this on every machine, and I don't want to tell people to go in there if they don't know what they're doing. So I'd like to change this setting through VBA.

I'm on NT, which is probably why the address is a little different.

Thanks again

Kyle

 

[Hasit]

Yes it is different on NT (I am looking at W2K). I am not sure how you would do it through code, and unless someone else can help, it might be a very lonely process making the changes!

 

[Guest_imported]

Hello There; I am a tech guy. Customers cumputer infected with x97m.brep virus. I cleaned his computer, and also installed office 97 again. when he tried to save some files with macro, it goes to an endless loop to save. In task manager it shows Excell CPU %99. What is wronge???
Thanks, Khosrow T.D. (takdehghan@yahoo.com)

 

[KyleS]

Well X97M.Brep,

First off I would suggest starting a new thread on this subject so others who may be able to help will see it.

But I will throw a few suggestions out to see if I can't be of some assistance...

Did the loop work before you reinstalled Office '97? If this is the first time the code has been used, it's probably just written incorrectly, but I can't tell you withou seeing the code...

The task manager should say "Excel 99%" because since you're stuck in an endless loop, excel really is working and therefore using your PC's resources.

If you could past a copy of the loop, I will be more than happy to look at it for you. Although I do recomend you start a new thread...

Kyle :