Active window "frozen"

R

Randy Lefferts

I have a file that evidently has 10 worksheets. I can
only see one worksheet AND the window, when looking at
the worksheet, opens up "frozen" and it can't be moved. I
can't maximize the window nor can I close the active
window. Scrolling is not an option with the scrollbar
although I can move around ONE sheet via the arrow keys.

Is there something in vba that may have turned off the
ability to resize the window? Any help is most
appreciated.

Using Excel 2002 (XP)
 
J

Jim Rech

Is there something in vba that may have turned off the
ability to resize the window?

Tools, Protection, Protect Workbook and selecting Windows, will do what you
described I think.
 
G

Guest

Thanks Jim, I was afraid of that. Saw that the workbook
was protected/passworded. Why on earth the person would
do that to this particular workbook is beyond me. All
they did was restrict the user from using 9/10's of the
workbook. Must have been an oversight. Thanks again!
 
Top