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

VBA ActiveWindow.WindowState Problem
 

are you running different versions of excel?

"JK" wrote:

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

VBA ActiveWindow.WindowState Problem
 

Yes. I wrote the application with Excel97, but have succesfully used it with
Excel97 and newer. The users encountering the problem have Excel2002.

"ben" wrote in message
...
are you running different versions of excel?

"JK" wrote:

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