ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   webbrowser - excel - modifications (https://www.excelbanter.com/excel-discussion-misc-queries/67211-webbrowser-excel-modifications.html)

[email protected]

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.....


David McRitchie

webbrowser - excel - modifications
 
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.....






All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com