Excel 2002: Can I protect the whole file in a single step ? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Mr. Low 8/29/2007 6:57 AM PST   Question   Dear Sir, I know how to protect a worksheet (page) at a time by going to Tool > Protection > Protect Sheet > Enter Passwords Twice. If I have a file with 20 worksheets, may I know what is the shortest way to protect the entire file with a password ? Also the above protection feature is to prevent someone from editing or deleting the entries. When If I save the file in the shared drive or even my personal drive, is there a way to prevent the file from being deleted intentionally or accidentally with a password ? I would appreciate very much if you could provide me with the helpful information in this area Thanks Low -- A36B58K641     Was this post helpful to you?         Reply |   Top           tc 8/29/2007 8:28 AM PST   Answer   On Aug 29, 6:58 pm, Mr. Low <lsk2...@discussions.microsoft.com> wrote: > Dear Sir, > > I know how to protect a worksheet (page) at a time by going to Tool > > Protection > Protect Sheet > Enter Passwords Twice. > > If I have a file with 20 worksheets, may I know what is the shortest way to > protect the entire file with a password ? > > Also the above protection feature is to prevent someone from editing or > deleting the entries. > > When If I save the file in the shared drive or even my personal drive, is > there a way to prevent the file from being deleted intentionally or > accidentally with a password ? > > I would appreciate very much if you could provide me with the helpful > information in this area > > Thanks > > Low > > -- > A36B58K641 The simplest way is, after having finished your work in the file click on File, Save as, and then in the window that pops up click on tools and general options. Here you will have two options, one is to give the user read only access and the other is to allow opening of the file only if the correct password is supplied.     Was this post helpful to you?         Reply |   Top           Mr. Low 8/29/2007 3:49 PM PST   Hello tc, Thanks for your info. Low -- A36B58K641 "tc" wrote: > On Aug 29, 6:58 pm, Mr. Low <lsk2...@discussions.microsoft.com> wrote: > > Dear Sir, > > > > I know how to protect a worksheet (page) at a time by going to Tool > > > Protection > Protect Sheet > Enter Passwords Twice. > > > > If I have a file with 20 worksheets, may I know what is the shortest way to > > protect the entire file with a password ? > > > > Also the above protection feature is to prevent someone from editing or > > deleting the entries. > > > > When If I save the file in the shared drive or even my personal drive, is > > there a way to prevent the file from being deleted intentionally or > > accidentally with a password ? > > > > I would appreciate very much if you could provide me with the helpful > > information in this area > > > > Thanks > > > > Low > > > > -- > > A36B58K641 > > The simplest way is, after having finished your work in the file click > on File, Save as, and then in the window that pops up click on tools > and general options. Here you will have two options, one is to give > the user read only access and the other is to allow opening of the > file only if the correct password is supplied. > >     Was this post helpful to you?         Reply |   Top           Mr. Low 8/30/2007 6:10 AM PST   Helo tc, I entered password for the two purposes as you mentioned. However, I can still open the file witout having to key in my password. I can also amend the file without having to key in my password. May I know why ? Thanks Low -- A36B58K641 "tc" wrote: > On Aug 29, 6:58 pm, Mr. Low <lsk2...@discussions.microsoft.com> wrote: > > Dear Sir, > > > > I know how to protect a worksheet (page) at a time by going to Tool > > > Protection > Protect Sheet > Enter Passwords Twice. > > > > If I have a file with 20 worksheets, may I know what is the shortest way to > > protect the entire file with a password ? > > > > Also the above protection feature is to prevent someone from editing or > > deleting the entries. > > > > When If I save the file in the shared drive or even my personal drive, is > > there a way to prevent the file from being deleted intentionally or > > accidentally with a password ? > > > > I would appreciate very much if you could provide me with the helpful > > information in this area > > > > Thanks > > > > Low > > > > -- > > A36B58K641 > > The simplest way is, after having finished your work in the file click > on File, Save as, and then in the window that pops up click on tools > and general options. Here you will have two options, one is to give > the user read only access and the other is to allow opening of the > file only if the correct password is supplied. > >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies