ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Freeze Panes loss (https://www.excelbanter.com/excel-worksheet-functions/449483-freeze-panes-loss.html)

Walter Briscoe

Freeze Panes loss
 
I apologise that I have not made a reasonable attempt to answer this
question for myself.
<http://groups.google.com/advanced_search?num=100&q=& used to do a
Google Groups Advanced Search.
It now opens <https://groups.google.com/forum/#!overview
;(

I use Excel 2003.
I lose Freeze Panes settings in the new object if
1) I create a New Window with Window\New Window.
or
2) I copy the active sheet with Edit\Move or Copy Sheet...

The VBA for Freeze Panes is ActiveWindow.FreezePanes = True.

I don't understand the relationship between the Active Sheet and the
Active Window, nor why I lose the Freeze Panes settings, nor how I could
do such operations without loss.

I would value any light on this subject. ;)
--
Walter Briscoe

GS[_2_]

Freeze Panes loss
 
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


Walter Briscoe

Freeze Panes loss
 
In message of Thu, 14 Nov 2013 00:49:00 in
microsoft.public.excel.worksheet.functions, GS
writes
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.


I know FreezePanes is a Window property.
I don't know how the Window Object relates to the Worksheet object.


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.


Sheets("foo").Copy Befo=Sheets(1) is an "Edit\Move or Copy Sheet..."

Sheets("foo").Select
Sheets("foo").Copy Befo=Sheets(1)
is the result of clicking on the sheet name and doing "Move or Copy..."
by a right click. As you say, that copies FreezePanes settings.

The same is done by clicking on the sheet name and doing "Edit\Move or
Copy Sheet..."

Clicking the sheet name and doing "Window\New Window" creates a Window
object, to which FreezePanes is not copied. The underlying VBA is
Sheets("foo").Select
ActiveWindow.NewWindow

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.

Thank you for the help.



HTH


--
Walter Briscoe

GS[_2_]

Freeze Panes loss
 
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



All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com