Password protecting multiple pages, and then some.

[Pistolade]

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

 

[GS]

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

 

[GS]

I forgot to mention you can also uncheck the *Select locked cells*
option in the *Protect sheet* dialog when setting protection.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Pistolade]

;1615775']I forgot to mention you can also uncheck the *Select locke
cells*
option in the *Protect sheet* dialog when setting protection.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

They need to be unhidden and I need to know a way to protect/unprotec
all pages at one time since I work on some 70+ pages daily

 

[GS]

;1615775']I forgot to mention you can also uncheck the *Select
locked cells*
option in the *Protect sheet* dialog when setting protection.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

They need to be unhidden and I need to know a way to
protect/unprotect all pages at one time since I work on some 70+
pages daily.

But you stated you did not want peaople to see the formulas!! When the
sheet is protected the formulas are not viewable but their results are
viewable because the cell remains visible.

Also, you need to apply protection to each sheet individually. This
requires looping through the Worksheets collection. There are a couple
ways to go with this:

1. Write a macro to protect all sheets when manually executed. Perhaps
something like...

Sub SetProtection()
Dim Wks As Worksheet
For Each Wks In ActiveWorkbook.Worksheets
Wks.Protect Password:="pwd"
Next
End Sub

...which doesn't require this macro be in the workbook being protected.

2. Have this done automatically via ThisWorkbook.Sheet_Activate event
whenever a worksheet is activated. (This requires macros be allowed
because the code must reside in the workbook)

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Sh.Protect Password:="pwd"
End Sub

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Pistolade]

;1615802']> 'GS[_2_ Wrote: --

;1615775']I forgot to mention you can also uncheck the *Select
locked cells*
option in the *Protect sheet* dialog when setting protection.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

They need to be unhidden and I need to know a way to
protect/unprotect all pages at one time since I work on some 70+
pages daily.-

But you stated you did not want peaople to see the formulas!! When the
sheet is protected the formulas are not viewable but their results are
viewable because the cell remains visible.

Also, you need to apply protection to each sheet individually. This
requires looping through the Worksheets collection. There are a couple
ways to go with this:

1. Write a macro to protect all sheets when manually executed. Perhaps
something like...

Sub SetProtection()
Dim Wks As Worksheet
For Each Wks In ActiveWorkbook.Worksheets
Wks.Protect Password:="pwd"
Next
End Sub

...which doesn't require this macro be in the workbook being protected.

2. Have this done automatically via ThisWorkbook.Sheet_Activate event
whenever a worksheet is activated. (This requires macros be allowed
because the code must reside in the workbook)

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Sh.Protect Password:="pwd"
End Sub

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Thank you, this is closer, however; when I use the code the first fe
pages lock correctly. Meaning when I open them I can look, but no
select. Then after the third page or so I can select them and view th
formula in the formula bar but the pages are still protected. I'm no
sure if this is something you have thoughts on how to fix or not, but i
must be done somehow. I cant have the cells be selectable. A sort o
look but don't touch type thing.
Does that give you a better understanding? I feel like I'
miscommunicating my reques

 

[GS]

Thank you, this is closer, however; when I use the code the first few

pages lock correctly. Meaning when I open them I can look, but not
select. Then after the third page or so I can select them and view
the
formula in the formula bar but the pages are still protected. I'm not
sure if this is something you have thoughts on how to fix or not, but
it
must be done somehow. I cant have the cells be selectable. A sort of
look but don't touch type thing.
Does that give you a better understanding? I feel like I'm
miscommunicating my request

Note that if a sheet is already protected, you must unprotect in order
make changes to the protection options.

If you uncheck the *Select locked cells* option then users can't select
any cells except those that are not locked. (Look but don't touch)

I mention checking the *Hidden* option so the formulas can't be seen if
*Select locked cells* is allowed.

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Pistolade]

;1615993']> Thank you, this is closer, however; when I use the code th
first few-

pages lock correctly. Meaning when I open them I can look, but not
select. Then after the third page or so I can select them and view
the
formula in the formula bar but the pages are still protected. I'm not
sure if this is something you have thoughts on how to fix or not, bu

it
must be done somehow. I cant have the cells be selectable. A sort of
look but don't touch type thing.
Does that give you a better understanding? I feel like I'm
miscommunicating my request-

Note that if a sheet is already protected, you must unprotect in order
make changes to the protection options.

If you uncheck the *Select locked cells* option then users can't selec

any cells except those that are not locked. (Look but don't touch)

I mention checking the *Hidden* option so the formulas can't be seen i

*Select locked cells* is allowed.

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Thank you,
-Pistolade