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