VBA ActiveWindow.WindowState Problem

  • Thread starter Thread starter JK
  • Start date Start date
J

JK

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WindowState = xlMaximize has opposite effect?! 12
Please Help with WindowState 2
Please Help if You Can 3
Dictator program question 3
Range.Select error and screen maximizing error in Workbook_Open() 3
Excel Excel Macro Help 0
maximizing the size of a UserForm 11
External Data Toolbar 2

Back
Top