Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Password protecting multiple pages, and then some. (Solved)
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 Last edited by Pistolade : February 4th 14 at 08:08 PM Reason: Solved |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protecting multiple pages, and then some.
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protecting multiple pages, and then some.
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 --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#4
|
|||
|
|||
Quote:
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protecting multiple pages, and then some.
'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 --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com 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 --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#6
|
|||
|
|||
Quote:
Does that give you a better understanding? I feel like I'm miscommunicating my request |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password protecting multiple pages, and then some.
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 --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#8
|
|||
|
|||
Quote:
Pistolade |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protecting multiple pages | New Users to Excel | |||
Password protecting multiple spreadsheets at once | Excel Discussion (Misc queries) | |||
Password Protecting a particular Sub | Excel Programming | |||
Password Protecting | Excel Discussion (Misc queries) | |||
Protecting Multiple sheets with prompt for password to unprotect | Excel Programming |