Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
My hide sheet option in excel is not working | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
how to hide rows in a protected sheet | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |