LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to cancel the Edit status

I use VC6 to write test data into excel file. The _Application, Workbooks,
_Workbook,Sheets and _Worksheet are initialized when program start, and test
result can be writen correctly.
But when user double click one Cell on active sheet, this Cell will be in
edit stauts, the GetRange function will cause program crash.

Range myrange;
myrange = workSheet.GetRange(COleVariant(strLine),COleVarian t(strLine));

I try to use the SendKeys function to send "ESC", still couldn't change
foucs.
Kindly help how can I cancel the Edit status or How to disable the Edit
funtion.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit Links - Status Unknown Hillheader Links and Linking in Excel 2 April 27th 23 03:41 AM
excel status bar says "double-click to edit PBrush" leo Excel Worksheet Functions 2 April 7th 06 04:08 PM
status bar says "double-click to edit pbrush" leo Excel Discussion (Misc queries) 0 April 6th 06 07:37 PM
How to use Excel VBA to cancel Excel readonly status kobeting Excel Programming 2 March 17th 06 06:03 PM
Cancel Macro is user selects 'cancel' at save menu Mark Excel Programming 1 April 6th 05 05:45 PM


All times are GMT +1. The time now is 06:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"