gav

My 2 cents worth.

There are three types of protection and passwording(4 if you count VBA
projects)

1. Sheet Protection is what you need to "lock" or "unlock" cells for
editing. Can be passworded.

Protecting elements from all users. You can prevent users from inserting,
deleting, and formatting rows and columns, from changing the contents of
locked cells, and from moving the cursor to cells that are locked or to cells
that are unlocked.

Each sheet must be done individually unless you use a Macro.

2. Workbook Protection is used to lock the structure. This is what Vasant
is referring to. Can be passworded.

You can prevent users from adding or deleting worksheets, or displaying hidden
worksheets. You can also prevent users from changing the sizes or positions of
the windows you set up to display a workbook. These protections apply to the
entire workbook. This does not protect the sheet from editing.

3. Then there is File Protection. You put a password on the file so it
cannot be opened with out the PW.

To prevent anyone from viewing an Excel file you need to password-protect the
file from being opened in the first place.

XL97.....FileSave AsOptionsPassword to open

XL2002...FileSave AsToolsGeneral OptionsPassword to open

Gord Dibben Excel MVP


On Thu, 15 Apr 2004 10:33:40 +1000, "gav meredith" wrote:

um, neither did i???? When a person unprotects the workbook they could then
unhide the sheet anyway. The idea is to give certain users access to this
particular worksheet within the workbook....

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
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!!!!