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

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

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

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