stop multiple worksheets opening

  • Thread starter Thread starter cwtex
  • Start date Start date
C

cwtex

I've "inheirted" a workbook that when opened, all worksheet
automatically open in new windows.

The person that created the workbook doesn't know how he did it, and
haven't been able to find out how to turn it off.

Any suggestions?

Thank
 
Press the X at the upper right for all but one of the windows, then save the
workbook and close it. The next time you open it, no other windows should
open.

HTH,
Bernie
MS Excel MVP
 
Hi, cwtex,

There are two ways I can think of how this was done:
1) a macro was written to open them all up (which I
doubt if the person doesn't remember/know how he did it)
and
2) He went to Menu=>Window=>New Window and selected each
worksheet; then saved the file; you can arrange the
windows by tiling or cascade etc. Try this (to undo,
simply close each window not wanted.)

jeff
 
You must log in or register to reply here.

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

Multiple Worksheets 6
Move/Copy Worksheet with Macros 2
multiple workbooks in one file 3
Help with automatically opening another worksheet 4
Eliminate creation of backup document every time I open workbook? 1
how do I stop PERSONAL.XLSB from showing every time XL opens? 1
OPEN A WORKBOOK TO A SPECIFIC WORKSHEET 2
Relative worksheet reference clarified 4

Back
Top