Freeze Panes Overridden

  • Thread starter At Sea In The Desert
  • Start date
A

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top