| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding password an hidden sheets
is it possible to give a password to an hidden sheet?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding password an hidden sheets
On Mar 19, 12:27 pm, "thread" wrote:
is it possible to give a password to an hidden sheet? What is the goal? Password to protect sheet from changes? Or do you just not want anyone looking at it at all? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding password an hidden sheets
1.i have sheets that i dont want anyone to see
2 i have sheet that only can be change by automation and validation,beside this there is nothing that is suppose to br change by a user okrob כתב: On Mar 19, 12:27 pm, "thread" wrote: is it possible to give a password to an hidden sheet? What is the goal? Password to protect sheet from changes? Or do you just not want anyone looking at it at all? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding password an hidden sheets
On Mar 19, 5:06Â*pm, "thread" wrote:
1.i have sheets that i dont want anyone to see 2 i have sheet that only can be change by automation and validation,beside this there is nothing that is suppose to br change by a user okrob כתב: On Mar 19, 12:27 pm, "thread" wrote: is it possible to give a password to an hidden sheet? What is the goal? Â*Password to protect sheet from changes? Â*Or do you just not want anyone looking at it at all?- Hide quoted text - - Show quoted text - You'll need to do the following for the sheets you want to protect and hide. I'm not sure how the sheet will react when it's protected and you try to change it with validation etc... But you can always programmatically unprotect it then re-protect it after changes. Worksheets("Sheet1").Protect Password:="1234" 'Or whatever password you want. Substitute "Sheet1" with whatever your sheet name is, or refer to it as Sheet1.Protect Password:="1234" Worksheets("Sheet1").Visible = xlVeryHidden 'This hides the sheet so that it can only be accessed by programmatically unhiding it with the line: Worksheets("Sheet1").Visible = True |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding password an hidden sheets
thank you,that was very helpfull
okrob כתב: On Mar 19, 5:06Â*pm, "thread" wrote: 1.i have sheets that i dont want anyone to see 2 i have sheet that only can be change by automation and validation,beside this there is nothing that is suppose to br change by a user okrob כתב: On Mar 19, 12:27 pm, "thread" wrote: is it possible to give a password to an hidden sheet? What is the goal? Â*Password to protect sheet from changes? Â*Or do you just not want anyone looking at it at all?- Hide quoted text - - Show quoted text - You'll need to do the following for the sheets you want to protect and hide. I'm not sure how the sheet will react when it's protected and you try to change it with validation etc... But you can always programmatically unprotect it then re-protect it after changes. Worksheets("Sheet1").Protect Password:="1234" 'Or whatever password you want. Substitute "Sheet1" with whatever your sheet name is, or refer to it as Sheet1.Protect Password:="1234" Worksheets("Sheet1").Visible = xlVeryHidden 'This hides the sheet so that it can only be accessed by programmatically unhiding it with the line: Worksheets("Sheet1").Visible = True |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can hidden sheets be prevented from opening without a password? | Excel Worksheet Functions | |||
| How to password Protect when WORKSHEET is Very HIDDEN | Excel Worksheet Functions | |||
| Password protect a hidden tab | Excel Discussion (Misc queries) | |||
| how can I password hidden columns | New Users to Excel | |||
| Excel password but cant hide the sheets before entering password | Excel Programming | |||
Hybrid Mode
