adding password an hidden sheets
 

is it possible to give a password to an hidden sheet?

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?

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?

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

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