Freeze Window - lock

Z

zSplash

Is there any way to protect or lock a "freeze window" setting so that others
can't unfreeze the window, change the rows, and re-freeze the window,
thereby making other rows visible?

I hope this question is clear. My spreadsheet is password-protected, but
users have been changing the spreadsheet's "freeze view" as described above.

TIA
 
A

AlfD

Hi!

Depend on it: Excel is not proof against anyone with a modicum o
skill, guile or sheer bloody-mindedness.

On way of slowing their progress through your pitfalls, mantraps an
other blocks is to limit movement on the visible screen to your choic
of cells. For this use the Control Toolbar: Properties (for th
worksheet) and set a range in ScrollArea.

If you are really serious, you can remove the bits of the menubar yo
don't want people to get at (e.g. Window).
I won't attempt to take you down this road (lack of familiarity at th
very least) but others will be able to if you want it.

Al
 
Z

zSplash

Thanks, Alf, for the idea. I'll have to check how that works. Appreciate
the idea.

st.
 
Top