Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3 sheets in workbook, but visible only one?
Hi there I would like to ask you if there is possibility to resolve this issue - I have workbook including 3 sheets. I send this workbook to our customers. But I want to customer to see just Sheet1, Sheet2 and 3 should not be available. Is there any possibility for that? for sure, there is possible just to extract one sheet and paste it into new file, however, as I use data from other sheets, it would cause problem. Thanks a lot Cheers Pavel -- slaya_cz ------------------------------------------------------------------------ slaya_cz's Profile: http://www.excelforum.com/member.php...o&userid=16723 View this thread: http://www.excelforum.com/showthread...hreadid=472030 |
#2
|
|||
|
|||
You can hide worksheets: select the sheet to be hidden, then Format/Sheets/Hide
Unfortunately this operation is not password protected, so additional measure can be to protect the workbook with a password (in this case users cannot unhide hidden sheets): Tools/Protection/Workbook(check Structure, uncheck Window option, give password if you think it is necessary). Regards, Stefi slaya_cz ezt *rta: Hi there I would like to ask you if there is possibility to resolve this issue - I have workbook including 3 sheets. I send this workbook to our customers. But I want to customer to see just Sheet1, Sheet2 and 3 should not be available. Is there any possibility for that? for sure, there is possible just to extract one sheet and paste it into new file, however, as I use data from other sheets, it would cause problem. Thanks a lot Cheers Pavel -- slaya_cz ------------------------------------------------------------------------ slaya_cz's Profile: http://www.excelforum.com/member.php...o&userid=16723 View this thread: http://www.excelforum.com/showthread...hreadid=472030 |
#3
|
|||
|
|||
Good afternoon Slaya_cz You could make this more secure by marking the sheets as xlVeryHidden. To do this goto the VBE (alt + F11) and find the worksheet you want to hide under the Projects window on the left. Then set the Visible property (under the Property window) to 2 - xlSheetVeryHidden. This method can be protected by right clicking on the file name in the project window and selecting VBAProject Properties, and selecting the protection tab, check the lock project for viewing box and enter your password. This method is much more secure than the Workbook structure protection, but it can still be circumnavigated as can any of Excel's current security settings. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=472030 |
#4
|
|||
|
|||
If the data on sheet2 and sheet3 is important to keep private, don't send it to
the customer. Excel's security is not made for this kind of thing. The end customer could be looking at your hidden information within minutes of receiving your file. slaya_cz wrote: Hi there I would like to ask you if there is possibility to resolve this issue - I have workbook including 3 sheets. I send this workbook to our customers. But I want to customer to see just Sheet1, Sheet2 and 3 should not be available. Is there any possibility for that? for sure, there is possible just to extract one sheet and paste it into new file, however, as I use data from other sheets, it would cause problem. Thanks a lot Cheers Pavel -- slaya_cz ------------------------------------------------------------------------ slaya_cz's Profile: http://www.excelforum.com/member.php...o&userid=16723 View this thread: http://www.excelforum.com/showthread...hreadid=472030 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to link several sheets in single workbook for searching purposes. | Excel Discussion (Misc queries) | |||
In Excel, how do I print the workbook sheets to 2sided paper? | Excel Discussion (Misc queries) | |||
How do I convert an Excel workbook that has mulitple sheets into . | Excel Worksheet Functions | |||
Numbering sheets in workbook | Excel Worksheet Functions | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) |