In article , ?B?YnBlbHR6ZXI=?= wrote:
You should be able to hide the worksheet (with the sheet active, Format
Sheet
Hide), the protect the workBOOK. If you like, you can put a password onthe
protection. But realize that there are easy tools out there to crack Excel
passwords, so if the data is truly sensitive, this protection isn't very
secure...

Most secure way would be to only send the sheet you want them to see -
delete the other sheet and save it as <a different name ... and send them
that :)
If there are calculations on that other sheet that are shown in the one you
want them to see ... I don't know.

"Avinash" wrote:

I want to share an excel workbook for all on the network. However I do not
want one worksheet only to be accessed.
The person should be able to access all the other worksheets.
I tried protecting, but people can see the sheet but cant modify. I tried
adding a password, but with this you can either open the excel file or not.
Is this even possible in Excel?

Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)