I am trying to protect a couple of Excell pages so that a password is needed
to open them.
When the page is open I select : Tools/Protection/Protect sheet:
In the Protect Sheet box I type in my password then, under Allow all users
of this worksheet.
I have ticked Select locked cells and Select unlocked cells
Then I re enter my password and close the sheet/s

Next time I open the sheet/s it opens the sheet regardless of the
protection...
What I want to do is to be asked for the password before the sheet opens.
Is this possible to do in Excel?
Is it also possible to doin Word?

--
chequer
When the game is over, the King and the pawn share the same box.

We are getting sheets, pages, workbooks and documents confused. Workbook and
Word documents can be password protected, meaning that when someone tries to
open them they can't even open the file (document or workbook) without the
password.

Word does not have anything equivalent to Excel's sheets (pages are not the
same sheets). In Excel you can protect the sheets as you did it, but it is
designed to prevent changes to the sheets not to prevent viewing.

In Excel we don't open sheets, we open the workbook and we activate the
sheets. You can lock a sheet from viewing as follows:
1. Select the sheet and choose Format, Sheet, Hide
2. Choose Tools, Protection, Protect Workbook, check Structure and add a
password.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"chequer" wrote:

I am trying to protect a couple of Excell pages so that a password is needed
to open them.
When the page is open I select : Tools/Protection/Protect sheet:
In the Protect Sheet box I type in my password then, under Allow all users
of this worksheet.
I have ticked Select locked cells and Select unlocked cells
Then I re enter my password and close the sheet/s

Next time I open the sheet/s it opens the sheet regardless of the
protection...
What I want to do is to be asked for the password before the sheet opens.
Is this possible to do in Excel?
Is it also possible to doin Word?

--
chequer
When the game is over, the King and the pawn share the same box.

What I want to protect is all on the Sheet 1 tab and it so far has 201 lines.
If I added some irrelevant data into sheets 1 and two , would I then have a
Work book?
I'm 81 and not as cluey as I once was, so I'll just use a password to opem
the computer.
This should suffice.
Thanks for your reply.
--
chequer
When the game is over, the King and the pawn share the same box.


"Shane Devenshire" wrote:

We are getting sheets, pages, workbooks and documents confused. Workbook and
Word documents can be password protected, meaning that when someone tries to
open them they can't even open the file (document or workbook) without the
password.

Word does not have anything equivalent to Excel's sheets (pages are not the
same sheets). In Excel you can protect the sheets as you did it, but it is
designed to prevent changes to the sheets not to prevent viewing.

In Excel we don't open sheets, we open the workbook and we activate the
sheets. You can lock a sheet from viewing as follows:
1. Select the sheet and choose Format, Sheet, Hide
2. Choose Tools, Protection, Protect Workbook, check Structure and add a
password.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"chequer" wrote:

I am trying to protect a couple of Excell pages so that a password is needed
to open them.
When the page is open I select : Tools/Protection/Protect sheet:
In the Protect Sheet box I type in my password then, under Allow all users
of this worksheet.
I have ticked Select locked cells and Select unlocked cells
Then I re enter my password and close the sheet/s

Next time I open the sheet/s it opens the sheet regardless of the
protection...
What I want to do is to be asked for the password before the sheet opens.
Is this possible to do in Excel?
Is it also possible to doin Word?

--
chequer
When the game is over, the King and the pawn share the same box.