worksheet protection

[Frank]

I would need to protect a tab from being viewed even if
someone has access to copy it on his machine.

If I hide and protect the tab nothing keeps the individual
to copy the tab in a new file and unhide the data.

Any help would be appreciated

 

[Trevor Shuttleworth]

Frank

in the VB Editor, you can set the worksheet to "very hidden". It then won't
show up in the Format Sheets | Unhide list. Best bet is then to protect the
VBA Project with a password, even if you don't have any code. Then no-one
can see the sheets or names. Unfortunately, they can probably work it out
from references in other sheets.

In the VBE, in the Project Pane, select the worksheet. Then, in the
Properties Pane, select the Visible property and select xlSheetVeryHidden

It's not impregnable; most of the regulars in this group could work out that
there was a hidden sheet there, unhide it and unprotect it in a matter of
seconds. But the average user would probably be slowed down ... a bit.

Regards

Trevor

 

[frank]

Good da

It was the first time I try this group and I like it. I will share some tricks

Thanks for your help I will try to combine several of the tricks including what you¸suggested.