The FreezePanes feature belongs to the Window object, not the
Worksheet. Copying the worksheet (via VBA) doesn't include any window
settings, thus no frozen panes.

This is not the same as copying via the 'Ply' toolbar menu when you
right-click a sheet tab. This also copies the window settings and so
frozen panes persist in the copy.

HTH

--
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