Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SabrinaN
 
Posts: n/a
Default password to open Excel file option does not exist

I am using Excel 2000 and wish to password protect my file. When I go to
Tools, then Options, there is no option listed for password protection. When
I click on Tools, I do find a Protection option, but those only protect the
workbook and sheets for read-only, you are still able to open the file and
see the contents.
Where do I find the option to password protect the entire file from being
opened?
Thanks
My new email is:
  #2   Report Post  
Alan
 
Posts: n/a
Default

I'm using Office XP but I think its the same in 2000. Go 'File' 'Save as'
and on the right hand side of the dialogue box that appears there is
'Tools'. Click this and you'll get the menu for Read Only, Password to open
etc,
Regards,
"SabrinaN" wrote in message
...
I am using Excel 2000 and wish to password protect my file. When I go to
Tools, then Options, there is no option listed for password protection.
When
I click on Tools, I do find a Protection option, but those only protect
the
workbook and sheets for read-only, you are still able to open the file and
see the contents.
Where do I find the option to password protect the entire file from being
opened?
Thanks
My new email is:



  #3   Report Post  
Stevie_mac
 
Posts: n/a
Default

on the save as dialog box.

You'll find it!


"SabrinaN" wrote in message
...
I am using Excel 2000 and wish to password protect my file. When I go to
Tools, then Options, there is no option listed for password protection. When
I click on Tools, I do find a Protection option, but those only protect the
workbook and sheets for read-only, you are still able to open the file and
see the contents.
Where do I find the option to password protect the entire file from being
opened?
Thanks
My new email is:



  #4   Report Post  
SabrinaN
 
Posts: n/a
Default

THANK YOU!!!!! IT WORKED :D

"Alan" wrote:

I'm using Office XP but I think its the same in 2000. Go 'File' 'Save as'
and on the right hand side of the dialogue box that appears there is
'Tools'. Click this and you'll get the menu for Read Only, Password to open
etc,
Regards,
"SabrinaN" wrote in message
...
I am using Excel 2000 and wish to password protect my file. When I go to
Tools, then Options, there is no option listed for password protection.
When
I click on Tools, I do find a Protection option, but those only protect
the
workbook and sheets for read-only, you are still able to open the file and
see the contents.
Where do I find the option to password protect the entire file from being
opened?
Thanks
My new email is:




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
·Ranger
 
Posts: n/a
Default password to open Excel file option does not exist

OH THANKS! I've been looking for this feature in Excel 2000 for about an hour
now :D

"Stevie_mac" wrote:

on the save as dialog box.

You'll find it!


"SabrinaN" wrote in message
...
I am using Excel 2000 and wish to password protect my file. When I go to
Tools, then Options, there is no option listed for password protection. When
I click on Tools, I do find a Protection option, but those only protect the
workbook and sheets for read-only, you are still able to open the file and
see the contents.
Where do I find the option to password protect the entire file from being
opened?
Thanks
My new email is:




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
Make excel open file without Read Only dialog Saul Margolis Excel Discussion (Misc queries) 2 March 16th 05 03:30 PM
One file in Excel will not open. Eric Murphy Excel Discussion (Misc queries) 0 March 2nd 05 03:55 PM
Application hang when open a schema file in Excel Iv Excel Discussion (Misc queries) 0 February 16th 05 03:05 AM
Why can I not open an Excel Compound file with Office Excel xp? Wetcoast40 Excel Discussion (Misc queries) 1 February 4th 05 10:42 PM
Open a file in excel from a link in eplorer Dave Peterson Excel Discussion (Misc queries) 0 November 26th 04 01:25 AM


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