can't cancel command in CommandBeforeExecute event

J

jtz

I am working on a web application with owc11 spreadsheet in it. I need to
control all type of operations on spreadsheet so I use CommandBeforeExecute
event to monitor and cancel any unauthorited operation.all thing seem good
untill I come across fomatting range and merging cells (which commandID is
10066) ,the CommandBeforeExecute event can monitor their's trace but can not
stop them,which means even if you set cancel.value=true the formatting and
merging will be executed.
why this happen,is this a bug of OWC11 and anyone can resolve this problem?
a lot of thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OWC crashes in event procedure 1
Use of Cancel In Unload Event 2
Cancel an event from a second subroutine... 13
Cancel timer event if criteria not met 1
cancel event if data change 7
HealthService event ID 1103 and Health Service Modules event ID 10102 0
Cancel Event for no data in Macro? 3
Access 2007 and spreadsheet in a form 1

Top