Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi newsgroup
I've already posted some question because I have troubles with my Excel app. But now I think I filtered the real problem. My problem is that excel crashes when I use forms which have textboxes with a controlsource. I also have textboxes which I fill through code. So. Now I noticed that when I do not execute workbook_open I didn't get crashes (lost connection to data, or whatelse). Using workbook_open let's excel crash. Any idea how to handle, because it is very important, that I have to do some code when starting excel. The code only sets zooms like below: ' Sheet "Antrag" Sheets("Antrag").Select Range("p12").Select ActiveWindow.Zoom = 95 ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 ' Sheet "Prämienübersicht" Sheets("Prämienübersicht").Select Range("a1").Select ActiveWindow.Zoom = 80 ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 ' Sheet "Offerte UVGE" Sheets("Offerte_UVGE").Select Range("B1").Select ActiveWindow.Zoom = 100 ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 Thanks for the help! D.H. Lee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004 | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |