How do I hide a sheet, that others will not be able to see it?
 

I have to send out an xls. to a lot of people, where I have a lot of
vlookups, functions etc. which goes to quite sensitive data. So I would like
to hide and protect with passwors these sheets in a way, that they do not see
them, is there any possibility for that?

Thank you
Regards

How do I hide a sheet, that others will not be able to see it?
 

Petya,

You can protect the sheet, but not in such a way that people can't crack the password / protection
and see your sensitive data.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
I have to send out an xls. to a lot of people, where I have a lot of
vlookups, functions etc. which goes to quite sensitive data. So I would like
to hide and protect with passwors these sheets in a way, that they do not see
them, is there any possibility for that?

Thank you
Regards

How do I hide a sheet, that others will not be able to see it?
 

Bernie,

That is what I felt, so there is no way to achieve that they do not even see
the sheets? Becuase if they see those numbers is already bed:-)
Thx a lot

Petya

"Bernie Deitrick" wrote:

Petya,

You can protect the sheet, but not in such a way that people can't crack the password / protection
and see your sensitive data.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
I have to send out an xls. to a lot of people, where I have a lot of
vlookups, functions etc. which goes to quite sensitive data. So I would like
to hide and protect with passwors these sheets in a way, that they do not see
them, is there any possibility for that?

Thank you
Regards

How do I hide a sheet, that others will not be able to see it?
 

Petya,

You can hide the sheet (Format / Sheet... Hide) and protect the workbook with a password (Tools /
Protection / Protect Workbook), so that casual users won't see the numbers, but your numbers will
be there in the workbook, and a sophisticated user will be able to see them.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
Bernie,

That is what I felt, so there is no way to achieve that they do not even see
the sheets? Becuase if they see those numbers is already bed:-)
Thx a lot

Petya

"Bernie Deitrick" wrote:

Petya,

You can protect the sheet, but not in such a way that people can't crack the password /
protection
and see your sensitive data.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
I have to send out an xls. to a lot of people, where I have a lot of
vlookups, functions etc. which goes to quite sensitive data. So I would like
to hide and protect with passwors these sheets in a way, that they do not see
them, is there any possibility for that?

Thank you
Regards

How do I hide a sheet, that others will not be able to see it?
 

Ok, if a sophistacated user crak it, he can take it:-) But my problem is that
I do not want to protect the whole workbokk. Cause let's say, there is 7
sheets in my wbook, out of it, I want to keep 2 to be accessible 5to edit,
write etc....) to everybody, but I want to hide the 5 other in a way, that
they do not see them, and with the unhide either, just only with password. Is
it possible?
Thx really

Petya

"Bernie Deitrick" wrote:

Petya,

You can hide the sheet (Format / Sheet... Hide) and protect the workbook with a password (Tools /
Protection / Protect Workbook), so that casual users won't see the numbers, but your numbers will
be there in the workbook, and a sophisticated user will be able to see them.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
Bernie,

That is what I felt, so there is no way to achieve that they do not even see
the sheets? Becuase if they see those numbers is already bed:-)
Thx a lot

Petya

"Bernie Deitrick" wrote:

Petya,

You can protect the sheet, but not in such a way that people can't crack the password /
protection
and see your sensitive data.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
I have to send out an xls. to a lot of people, where I have a lot of
vlookups, functions etc. which goes to quite sensitive data. So I would like
to hide and protect with passwors these sheets in a way, that they do not see
them, is there any possibility for that?

Thank you
Regards

How do I hide a sheet, that others will not be able to see it?
 

Petya,

Yes, it is possible. Don't protect the worksheets that you want to have accessible. Protecting the
_workbook_ only protects the workbook's structure - hidden sheets, etc. The option to hide or
unhide a sheet will be greyed out when the workbook is protected.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
Ok, if a sophistacated user crak it, he can take it:-) But my problem is that
I do not want to protect the whole workbokk. Cause let's say, there is 7
sheets in my wbook, out of it, I want to keep 2 to be accessible 5to edit,
write etc....) to everybody, but I want to hide the 5 other in a way, that
they do not see them, and with the unhide either, just only with password. Is
it possible?
Thx really

Petya

"Bernie Deitrick" wrote:

Petya,

You can hide the sheet (Format / Sheet... Hide) and protect the workbook with a password (Tools
/
Protection / Protect Workbook), so that casual users won't see the numbers, but your numbers
will
be there in the workbook, and a sophisticated user will be able to see them.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
Bernie,

That is what I felt, so there is no way to achieve that they do not even see
the sheets? Becuase if they see those numbers is already bed:-)
Thx a lot

Petya

"Bernie Deitrick" wrote:

Petya,

You can protect the sheet, but not in such a way that people can't crack the password /
protection
and see your sensitive data.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
I have to send out an xls. to a lot of people, where I have a lot of
vlookups, functions etc. which goes to quite sensitive data. So I would like
to hide and protect with passwors these sheets in a way, that they do not see
them, is there any possibility for that?

Thank you
Regards

How do I hide a sheet, that others will not be able to see it?
 

Thanks Bernie, I thought that workbook protection still allows unhiding.
Thanks again

"Bernie Deitrick" wrote:

Petya,

Yes, it is possible. Don't protect the worksheets that you want to have accessible. Protecting the
_workbook_ only protects the workbook's structure - hidden sheets, etc. The option to hide or
unhide a sheet will be greyed out when the workbook is protected.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
Ok, if a sophistacated user crak it, he can take it:-) But my problem is that
I do not want to protect the whole workbokk. Cause let's say, there is 7
sheets in my wbook, out of it, I want to keep 2 to be accessible 5to edit,
write etc....) to everybody, but I want to hide the 5 other in a way, that
they do not see them, and with the unhide either, just only with password. Is
it possible?
Thx really

Petya

"Bernie Deitrick" wrote:

Petya,

You can hide the sheet (Format / Sheet... Hide) and protect the workbook with a password (Tools
/
Protection / Protect Workbook), so that casual users won't see the numbers, but your numbers
will
be there in the workbook, and a sophisticated user will be able to see them.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
Bernie,

That is what I felt, so there is no way to achieve that they do not even see
the sheets? Becuase if they see those numbers is already bed:-)
Thx a lot

Petya

"Bernie Deitrick" wrote:

Petya,

You can protect the sheet, but not in such a way that people can't crack the password /
protection
and see your sensitive data.

HTH,
Bernie
MS Excel MVP


"Petya" wrote in message
...
I have to send out an xls. to a lot of people, where I have a lot of
vlookups, functions etc. which goes to quite sensitive data. So I would like
to hide and protect with passwors these sheets in a way, that they do not see
them, is there any possibility for that?

Thank you
Regards