My usual use of "Window\New Window" ia to put 2 windows on the screen
and clicking one, so I can see 2 sheets in a workbook simultaneously.
I will need to be disciplined, in loading the new window to see
another sheet.

This does not 'copy' the 'active window'. It creates another open
instance (ie: Book1:2) of the workbook that was active when you clicked
the "New Window" menuitem. In this case you need to apply FreezePanes
to the new window instance.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com