hide sheet tab
I didn't say *save* the workbook with a password; I said *protect* it.
Tools | Protection | Protect Workbook
after you hide the worksheet.
--
Vasant
"gav meredith" wrote in message
...
yes but the person accessing the workbook could still unhide the sheet.
All
should have access to the workbook but only a few should have access to
the
hidden sheet. It is the contents of this sheet that i want hidden from a
select few......
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
You can hide the sheet and then protect the workbook (not the worksheet)
with a passsword.
--
Vasant
"gav meredith" wrote in message
...
Hi,
i have a workbook with which i want one of the sheets to not be viewed
without a password. Is this possible?? I dont simply want to hide the
sheet
as a person could unhide it. The contents of the sheet are not for all
eyes.
Any suggestions????? Cheers!!!!
|