webbrowser -> excel -> modifications

Hello,

I've following situation:

>From a external VBE application (not MS) i open a excel file in a
webbrowser.
Of course it's possible now to edit th excel sheet.

Is it possible to prevent modifications in the loaded excel sheet?


i tried it with disabling the excel alert:

webbrowser1.application.DisplayAlerts = false

.... but it didnt work


Thanks in advance.....

Depends on what you want, within Excel you can protect a
worksheet, but that is really to prevent accidental changes.
From another application that needs access to an Excel
file that really makes things complicated it can do anything
it wants.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

<h_boulder@gmx.at> wrote in message news:1138151043.014235.307130@z14g2000cwz.googlegroups.com...
> Hello,
>
> I've following situation:
>
> >From a external VBE application (not MS) i open a excel file in a
> webbrowser.
> Of course it's possible now to edit th excel sheet.
>
> Is it possible to prevent modifications in the loaded excel sheet?
>
>
> i tried it with disabling the excel alert:
>
> webbrowser1.application.DisplayAlerts = false
>
> ... but it didnt work
>
>
> Thanks in advance.....
>