Please Help with WindowState

[JK]

Dear Group:

I've tried another group for help, but they didn't know the answer; I'm
hoping one of you might.

I developed an application for Excel97 and newer. 2 of my users (only 2
thank goodness) are encountering a strange problem when they open the
program. The application window is maximized (as it should), but the active
window is not (though it should). Moreover, they can do nothing to enlarge
the window. I wrote a procedure for them
ActiveWindow.WindowState=xlMaximized, but they get a run-time error. I know
the file is ok because I had them email it to me and it works perfectly on
my computer (as did the procedure I wrote). Both seem to have current
editions of Excel.

Please help if you can. This is frustrating.

Thank you in advance.

Jim Kobzeff

 

[Dave Peterson]

Is the workbook protected with windows option checked?

 

[Ken Macksey]

Hi

Don't really know, but it sounds like it is acting as if the workbook
structure is protected on those 2 systems. Are there any buttons(minimize,
maximize, close) on the active window when displayed on those 2 systems? Is
there anything different about those 2 systems, excel version, windows
version etc?


Ken