Thread: hide sheet tab
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default 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!!!!