Freeze Panes Overridden

[At Sea In The Desert]

I have frozen 5 columns and 3 rows (at cell F4) on a sheet and protected the
sheet with the Select Locked Cells, Select Unlocked Cells, Format Cells and
Use AutoFilter options selected. When someone uses the Split Screen
function, it completely removes the Freeze Panes settings which cannot be
reset without unprotecting the sheet.

Is there a way I can design the sheet to stop others from being able to use
the Split Screen function?

 

[Ken Zerkel]

I have the same problem. I'm about to start going 1 by 1 with my team to see if it's when any user using the split-screen causes this problem, or if we can at least isolate the conditions that cause this to occur. But no answers yet?



At Sea In The Desert wrote:

Freeze Panes Overridden
24-Sep-09

I have frozen 5 columns and 3 rows (at cell F4) on a sheet and protected th
sheet with the Select Locked Cells, Select Unlocked Cells, Format Cells an
Use AutoFilter options selected. When someone uses the Split Scree
function, it completely removes the Freeze Panes settings which cannot b
reset without unprotecting the sheet

Is there a way I can design the sheet to stop others from being able to us
the Split Screen function?

Previous Posts In This Thread:

Freeze Panes Overridden
I have frozen 5 columns and 3 rows (at cell F4) on a sheet and protected th
sheet with the Select Locked Cells, Select Unlocked Cells, Format Cells an
Use AutoFilter options selected. When someone uses the Split Scree
function, it completely removes the Freeze Panes settings which cannot b
reset without unprotecting the sheet

Is there a way I can design the sheet to stop others from being able to us
the Split Screen function?

EggHeadCafe - Software Developer Portal of Choice
The Lowly HTTP HEAD Request
http://www.eggheadcafe.com/tutorial...9-f82f59991517/the-lowly-http-head-reque.aspx