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

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
>
>
>

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

"ben" <ben@discussions.microsoft.com> wrote in message
news:B03D6572-8C12-4A64-8777-E5CA6E81D4A4@microsoft.com...
> 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
>>
>>
>>