[RESOLVED] Badly needed excel-vba question

[VBKNIGHT]

How can you disable a macro virus protection using excel-vba.
So that everytime you open this certain workbook it will automatically disable the macro virus protection.

Note: The workbook should be the one containing the vba script.

is it possible?

ur response is very much appreciated.

[flint]

I think that you put this in the Workbook_Open event:

'Try this
Application.DisplayAlerts = False

I'm sure there's another way as well

Regards,
Flint Puckett

[VBKNIGHT]

I've tried putting it on workbook on_open event but it doesn't work. The application scan the workbook before it open.

Btw, I'm using excel2000.

[TheOnly]

Hi VBKNIGHT !!!

You can't avoid 1 time the macro warning if the user has choicen this. (Only if you change this outside Excel)

Tho change them, sorry I can't remember. I found this
1 time in an excel Virus for 97 version.

if I figure out how to make this possible in Excel 2000 I will reply.

-cu TheOnly

[flint]

I'm using Xcel 2000 as well. Yes I've tried it as well....that only works on certain display dialogs. I have a way to do this on your system. Go to Tools then Macros then Security and set the security level to Low. Note that this change only takes place on your system. I think that Microsoft intentionally placed the security dialog away from normal objects so that people could not disable this feature without the users consent. It makes sense to me...but it is a bit "goudy". Create your application in VB to avoid such annoyances.

Cordially,
Flint

[tclere]

If this was possible, what use would macro protection serve? It was designed to prevent the spread of macro virus'. If you could disable it within a vba macro you just defeated it's purpose!

[VBKNIGHT]

well this was a long time ago but it is possible thru registry modification.