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

On Mar 19, 12:27 pm, "thread" <yaniv...@gmail.com> 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?

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" <yaniv...@gmail.com> 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?

On Mar 19, 5:06Â*pm, "thread" <yaniv...@gmail.com> 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" <yaniv...@gmail.com> 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

thank you,that was very helpfull

okrob כתב:
> On Mar 19, 5:06Â*pm, "thread" <yaniv...@gmail.com> 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" <yaniv...@gmail.com> 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