Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hang when formula bar open
I'm embedding Excel in a VB app, and I've found that when the user is editing the formula in a cell, that certain automation calls hang - they bring up VB's Switch To/Retry/Cancel dialog. Is there any way to programmatically click the checkmark to get out of formula edit mode so that the document may manipulated? To reproduce, create a form with a button and a webbrowser control. Add the following code:
Private Sub Command1_Click() Dim wb As Excel.Workbook Dim ws As Excel.Worksheet Dim w As Excel.Window Set wb = WebBrowser1.Document Set ws = wb.ActiveSheet Set w = wb.Windows(1) End Sub Private Sub Form_Load() WebBrowser1.Navigate2 "file:///C:/test.xls" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Long time to launch/open/hang Excel 2003 | Excel Discussion (Misc queries) | |||
Why does Excel hang up when trying to open files? | Charts and Charting in Excel | |||
excel 2003 always hang when open more than 1 file | Excel Discussion (Misc queries) | |||
Why does Excel hang after clicking on file-open-dropdown box | Excel Discussion (Misc queries) | |||
Application hang when open a schema file in Excel | Excel Discussion (Misc queries) |