I have several pages, and from my understanding can only do this with
a macro, however I don't speak VB.
My intentions are to Lock multiple pages (with the ability to unlock
if needed), however it doesn't stop there. When you protect a sheet
one at a time you can select, or rather un-select, an option that
allows/disallows users to select locked cells. I need this to be
disallowed.
Meaning I cant have people reading the formulas behind the cells
values.
Thank you
Jody

If you also check the *Hidden* option on the *Protection* tab of the
*Format Cells* dialog, people will not see formulas when sheet
protection is applied.

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