Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default protection

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WS Protection: Different Levels of Protection on Different Ranges Carmi Excel Discussion (Misc queries) 4 August 31st 07 02:26 PM
Cell Protection vs. Worksheet Protection kmwhitt Excel Discussion (Misc queries) 4 September 24th 06 02:37 AM
Worksheet protection is gone and only wokbook protection can be se Eric C. Excel Discussion (Misc queries) 4 May 2nd 06 04:50 PM
Protection... danielle Excel Discussion (Misc queries) 3 July 6th 05 07:19 PM
Protection mac Excel Worksheet Functions 2 April 25th 05 06:18 PM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"