View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
 
Posts: 78
Default VBA ActiveWindow.WindowState Problem

Dear Group:

Forgive me if this issue is not appropriate for this group, but I think it
might be related to Excel and am hoping someone has the answer.

Several users of my application are encountering this strange window
behavior: After opening the program, their Active.Window.WindowState is not
maximized (causing the worksheets to appear about the size of a credit
card). I tried writing a procedure ActiveWindow.WindowState=xlMaximized they
could call from my toolbar but they get a Run Time error. When I open their
file on my computer, the WindowState is maximized (and the procedure I wrote
doesn't cause an error), so I have no way of knowing what's going on with
them. Any suggestions?

Thank you in advance.

Jim Kobzeff