Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default Make Workbook Password protected tp open

Hello,

How can I make a workbook so you need a password to open it period. In other
words, I don't want anyone to open it to view the contents in in read only
unless they have the password.

Thanks!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Make Workbook Password protected tp open

Open Help, look up "Open with password"

Stockwell43 wrote:

Hello,

How can I make a workbook so you need a password to open it period. In other
words, I don't want anyone to open it to view the contents in in read only
unless they have the password.

Thanks!!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 169
Default Make Workbook Password protected tp open

In article , Bob I wrote:
Open Help, look up "Open with password"

Stockwell43 wrote:

Hello,

How can I make a workbook so you need a password to open it period. In other
words, I don't want anyone to open it to view the contents in in read only
unless they have the password.


Note, however, that ther are many password crackers/removers out there. XL
passwords will not stop someone that really wants to see the spreadsheet.
If there's stuff you don't want seen, don't include it. :)
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default Make Workbook Password protected tp open

Do a FILE/SAVE, or if the file has been previously saved FILE/SAVE AS and at
the top of the file list on the right is a TOOLS drop down list. Click the
TOOLS drop down button and select GENERAL OPTIONS. You can set a password to
open the file, and if you want to limit who can modify it another password to
make changes to the file.

--
Kevin Backmann


"Stockwell43" wrote:

Hello,

How can I make a workbook so you need a password to open it period. In other
words, I don't want anyone to open it to view the contents in in read only
unless they have the password.

Thanks!!

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default Make Workbook Password protected tp open

Excellent, thanks Kevin!!

"Kevin B" wrote:

Do a FILE/SAVE, or if the file has been previously saved FILE/SAVE AS and at
the top of the file list on the right is a TOOLS drop down list. Click the
TOOLS drop down button and select GENERAL OPTIONS. You can set a password to
open the file, and if you want to limit who can modify it another password to
make changes to the file.

--
Kevin Backmann


"Stockwell43" wrote:

Hello,

How can I make a workbook so you need a password to open it period. In other
words, I don't want anyone to open it to view the contents in in read only
unless they have the password.

Thanks!!



Reply
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
PAssword protected file will not open jetta878 Excel Discussion (Misc queries) 9 January 7th 09 06:17 PM
Excel macro to open a password protected workbook Stephen C Excel Discussion (Misc queries) 8 December 1st 08 05:36 AM
How to delete a password in a protected file that you can't open? lostinspace Excel Discussion (Misc queries) 1 April 30th 08 06:39 PM
Cannot open password-protected Excel File Sumit Excel Discussion (Misc queries) 0 March 6th 08 09:41 AM
Multiple workbook user's with Master workbook - all password protected Yvon Excel Discussion (Misc queries) 2 March 30th 05 01:34 PM


All times are GMT +1. The time now is 07:53 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"