Worksheet Visibility

[jbeb824]

I have a workbook that I send out to a few different individuals in my company. I want to make sure that only certain people can actually view one of the worksheets within the workbook. What would be the most efficient way to do this?

Thanks in advance!

 

[GlennUK]

The only really safe way is to only send the single sheet to them ... there are ways to unblock any method you can think of to hide sheets.

If you don't mind using a not completely break-in-proof method, then use the VBE to set certain sheets to have visibility of xlVeryHidden, and protect the VBA project and structure of the workbook with a password.