Any suggestion that you get will depend on macros and macros can be disabled.

There's no good way to protect data in excel with the kind of security that you
want.

If you have data that others shouldn't see, don't put it into excel. If you
have to use excel, then don't share it with others who can't be trusted.

Maybe it's time for separate workbooks for each user/type of user???

Dan Wood wrote:

I have managed to password protect tabs seperately, but how can i hide the
data in the tabs until the password has been entered?

--

Dave Peterson