how to disable Office alerts...

[Jarek Kujawa]

.... using code, when following hyperlinks in Excel?

 

[Jarek Kujawa]

is it possible in Excel 2003?

If not pls provide a solution in Excel 2007.

I tried MsoAlertButtonType.msoAlertButtonOKCancel but to na avail

 

[JLGWhiz]

DisplayAlerts = False

 

[Gord Dibben]

Jarek

I think you have to turn that off for the Office Application globally.

See this KB Article for preventing the alerts for hyperlinks.

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


Gord

 

[Jarek Kujawa]

thanks but that's not that the case, tried this before, doesn't work

 

[Jarek Kujawa]

I think you have to turn that off for the Office Application globally.

thks Gord, this is what I presumed

thanks for the link, looks like it is what I've been searching for