3 sheets in workbook, but visible only one?

S

slaya_cz

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
 
S

Stefi

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:
 
D

dominicb

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 t
hide under the Projects window on the left. Then set the Visibl
property (under the Property window) to 2 - xlSheetVeryHidden. Thi
method can be protected by right clicking on the file name in th
project window and selecting VBAProject Properties, and selecting th
protection tab, check the lock project for viewing box and enter you
password.

This method is much more secure than the Workbook structure protection
but it can still be circumnavigated as can any of Excel's curren
security settings.

HTH

Dominic
 
D

Dave Peterson

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.
 
Top