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

wrote in message oups.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.....