software

Hello,

I've following situation:

gt;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 workThanks 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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

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