View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
don H. Lee don H. Lee is offline
external usenet poster
 
Posts: 10
Default Error in my App??

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