ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   is there any way to avoid displaying alert pop-up in DSOFramer? (https://www.excelbanter.com/excel-programming/334138-there-any-way-avoid-displaying-alert-pop-up-dsoframer.html)

Engin H.

is there any way to avoid displaying alert pop-up in DSOFramer?
 
Hello everybody
i am developing an application in .NET and i am using DSOFramer.ock component.
i protect my worksheet that i open with DSOframer in a web page.
but when user double-click on sheet, a pop-up message about protection
appears.
and i want to block such pop-up alerts.
"excel.DisplayAlerts = False" is not working.
"FramerControl.ActiveDocument.Application.DisplayA lerts = False" is also not
working. (cannot find displayalerts property)
can anybody help me to solve this problem?
Thanks
Engin H.

okaizawa

is there any way to avoid displaying alert pop-up in DSOFramer?
 
Hi,
How about "Application.EditDirectlyInCell = False"
or do Excel's menu Tools Options Edit Edit directly in cell.

Double-clicking a formula that has references to other cells makes a jump.
to avoid it, hide that formula (Format Cell Protection Hidden).

--
HTH
okaizawa

Engin H. wrote:
Hello everybody
i am developing an application in .NET and i am using DSOFramer.ock component.
i protect my worksheet that i open with DSOframer in a web page.
but when user double-click on sheet, a pop-up message about protection
appears.
and i want to block such pop-up alerts.
"excel.DisplayAlerts = False" is not working.
"FramerControl.ActiveDocument.Application.DisplayA lerts = False" is also not
working. (cannot find displayalerts property)
can anybody help me to solve this problem?
Thanks
Engin H.



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

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