stop multiple worksheets opening

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
 
B

Bernie Deitrick

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
 
J

jeff

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
 
Top