A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

password to open workbook



 
 
Thread Tools Display Modes
  #1  
Old October 6th, 2003, 10:53 PM
Margaret
external usenet poster
 
Posts: n/a
Default password to open workbook

How to set up that it is a password is required to open a
workbook
  #2  
Old October 6th, 2003, 11:06 PM
John Wilson
external usenet poster
 
Posts: n/a
Default password to open workbook

Margaret,

File/SaveAs
From the upper right of the Dialog box...."Tools"
From the dropdown..."General Options"

John


"Margaret" wrote in message
...
How to set up that it is a password is required to open a
workbook



  #3  
Old October 7th, 2003, 12:02 AM
Margaret
external usenet poster
 
Posts: n/a
Default password to open workbook

Thx. my coworkers and I do not have "General Options"
under Tools. We have "Options" "General" which does not
have a password indicator.

-----Original Message-----
Margaret,

File/SaveAs
From the upper right of the Dialog box...."Tools"
From the dropdown..."General Options"

John


"Margaret" wrote in

message
...
How to set up that it is a password is required to open

a
workbook



.

  #4  
Old October 7th, 2003, 01:29 AM
John Wilson
external usenet poster
 
Posts: n/a
Default password to open workbook

Margaret,

It's on the "Save As" dialog box that pops up when you
do a "File/SaveAs".
It's in the upper right hand corner of that "SaveAs" dialog box
and when you click on it (Tools), there should be a choice
for "General Options". Within the "General Options"
you can choose a "Password to Open" and/or a
"Password to Modify".

At least that's the way it is on Excel 2000.
If the above doesn't work, please post back with what
version you're using.

John


"Margaret" wrote in message
...
Thx. my coworkers and I do not have "General Options"
under Tools. We have "Options" "General" which does not
have a password indicator.

-----Original Message-----
Margaret,

File/SaveAs
From the upper right of the Dialog box...."Tools"
From the dropdown..."General Options"

John


"Margaret" wrote in

message
...
How to set up that it is a password is required to open

a
workbook



.



  #5  
Old October 7th, 2003, 04:37 PM
Margaret
external usenet poster
 
Posts: n/a
Default password to open workbook

Thanks John. I never noticed the "Tools" button
under "Save As"............I will pass the info to my
coworkers.

Thanks again.
-----Original Message-----
Margaret,

It's on the "Save As" dialog box that pops up when you
do a "File/SaveAs".
It's in the upper right hand corner of that "SaveAs"

dialog box
and when you click on it (Tools), there should be a choice
for "General Options". Within the "General Options"
you can choose a "Password to Open" and/or a
"Password to Modify".

At least that's the way it is on Excel 2000.
If the above doesn't work, please post back with what
version you're using.

John


"Margaret" wrote in

message
...
Thx. my coworkers and I do not have "General Options"
under Tools. We have "Options" "General" which does not
have a password indicator.

-----Original Message-----
Margaret,

File/SaveAs
From the upper right of the Dialog box...."Tools"
From the dropdown..."General Options"

John


"Margaret" wrote in

message
...
How to set up that it is a password is required to

open
a
workbook


.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:26 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.