ExcelBanter - Warning the user about closing Windows:1.

There's no Window_BeforeClose event, so you cannot tell when this happens.
There's only the Activate/Deactivate, which is too late, as there's no
Cancel argument.

Maybe Protect the WB, including windows and provide the user with
buttons/menu options to manipulate the windows in code, as they will not be
able to interactively.

Otherwise, possibly Chip's recent VBA subclasser and trap the message may
work:

<msg
Nick,

Will you add a link to this file/concept on your site ?

I have added a link to the SubClassForVSCROLL.xls workbook on my Downloads
page (www.cpearson.com/excel/download.htm) under the topic "SubClassing the
ActiveWindow". It is also listed on my Topics page
(www.cpearson.com/excel/topic.htm ) under the "SubClassing" entry.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)
</msg

NickHK

"Walden2" wrote in message
oups.com...
Nick -

I opened a new workbook and split and froze the screen horizontally and
vertically.

I then created a New Window of the same workbook.

When I close Book1:1, the split screen info is no longer available. If
I close Book1:2, it is.

I have a special menu that I ask users to use when closing multiple
windows of the same workbook and if they do, they'll close the 2nd
window and preserve the split screens on all the tabs. Invariably,
however, I or a user will close the Window 1, losing the split screens.
Many users haven't learned how to split and freeze screens and there
are a lot of tabs, so I wanted to evoke a warning when manually closing
Window 1.

Thanks for your help.

Walden

NickHK wrote:
Walden,
Describe the steps to produce this behaviour.

NickHK

"Walden2" wrote in message
ups.com...
If you view 2 windows of the same workbook, and you close Windows:1,
all original formatting is lost.
Not so if you close Windows:2.

Is there a way to warn users that they will lose formatting if they
close Windows:1?

Thanks,

Walden