Active window "frozen"

  • Thread starter Thread starter Randy Lefferts
  • Start date Start date
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)
 
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.
 
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!
 

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

Frozen rows setting gets lost 5
Hyperlink to move the cursor to the top of the frozen panes 3
Comments Not displaying Correctly With Panes Frozen? 1
scrolling is frozen-how to free up?? 1
cells are frozen 1
Freeze panes problems in shared workbook 2
Drop down list & frozen panes 3
Cannot navigate between cells using arrow keys 2

Back
Top