No password protect workbook box in Tools>Options>General

As is the case with much of this limited CD that was installed, some 
important features are missing. I want to password protect any given 
workbook. When I went to help (since the Tools>Protection didn't work) it 
told me to go to Tools>Options>General, and click on the box that said to 
password protect the workbook. As usual, this version has nothing of the sort 
on the General tab under Options. Now what?
0
MS1 (44)
7/16/2005 4:40:02 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
650 Views

Similar Articles

[PageSpeed] 25

Why don't you get a full version if you expect full version capability? I'm
at a loss...
*******************
~Anne Troy

www.OfficeArticles.com


"MS" <MS@discussions.microsoft.com> wrote in message
news:A42436DD-B3CF-4D1F-ACDA-C353AAAD971C@microsoft.com...
> As is the case with much of this limited CD that was installed, some
> important features are missing. I want to password protect any given
> workbook. When I went to help (since the Tools>Protection didn't work) it
> told me to go to Tools>Options>General, and click on the box that said to
> password protect the workbook. As usual, this version has nothing of the
sort
> on the General tab under Options. Now what?


0
ng1 (1444)
7/16/2005 4:42:41 AM
Hi!

This option is well hidden!

Goto File>Save As

In the dialog that opens.....way over on the right side near the top you'll 
see a little tiny word: Tools. Click that, then select General Options from 
the list.

Biff

"MS" <MS@discussions.microsoft.com> wrote in message 
news:A42436DD-B3CF-4D1F-ACDA-C353AAAD971C@microsoft.com...
> As is the case with much of this limited CD that was installed, some
> important features are missing. I want to password protect any given
> workbook. When I went to help (since the Tools>Protection didn't work) it
> told me to go to Tools>Options>General, and click on the box that said to
> password protect the workbook. As usual, this version has nothing of the 
> sort
> on the General tab under Options. Now what? 


0
biffinpitt (3171)
7/16/2005 5:34:22 AM
Reply:

Similar Artilces:

unwanted dialog box
hi everybody...... if i have a query (i have one in a macro), everytime i open the file the first thing that shows up is a dialog box asking me if i want t "activate auto atualization" (i dunno the exact words due to my exce portuguese version)... well, i dont want this dialog box to show up, i tried every singl button in excel options to make it go away, but i cant find solution.... anyone can help me -- redf1r ----------------------------------------------------------------------- redf1re's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3125 View t...

Having issues handling combo-box
I have a combo-box. I want to allow folks to enter by typing OR use the mouse to click on the dropdown. If they type I want it to auto-complete - that is no problem as the drop list style handles this. Where my problem arises is that when they pick the one they want I then need to know so I can do some added processing. I could handle the kill focus for when they type but that causes confusion when they use the mouse. What I want to be able to do is recognize when they hit <Enter> and act in a manner similar to that used when they use the mouse to pick an entry. The other possibili...

protecting sheet with combox
i'm trying to protect a sheet with a combo box in it. the combox list a bunch of values. each value you pick is linked to a formula which changes a price value in a different cell. i would like to protect the sheet so that the money value that appears in the cell can't be changed by the user. whenever i try to protect the sheet i then can't change the values in the comb box . i want to be able change the values in the combo box but have the formulas and automated cells protected. any ideas? ------------------------------------------------ ~~ Message posted from http://www....

Password Protect Two Sub-contact Lists
Hi everyone! I have a regular contact list, and within this list I have two subcontact lists. One is personal, and the other is personal business. How can I password protect the personal and personal business lists? Thanks for any help! Sorry, I just realized that there's a newsgroup dedicated to contacts. I'll post this there. Thanks! Nick2112@sympatico.ca wrote: > Hi everyone! > > I have a regular contact list, and within this list I have two > subcontact lists. One is personal, and the other is personal business. > How can I password protect the personal and...

Passwords #5
I would like to password protect a workbook so that when the workbook is selected to open a dialog box pops up asking for the password and after the password is entered correctly the workbook will then open. Thanks for the the help. Todd Todd, do a save as and look under options, depending on what version you are using and set a password to open -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address t...

Multiple hyperlinks from drop down box
Hi everyone, I am an excel beginner and this is my first time posting on this site. I have no experience with macros, and am only just starting to learn the ropes of other basic functions. Currently I have multiple worksheets set up. I want to create a drop down box in a worksheet that has 5 car dealership names. From this drop down box i want to be able to click on each one of these names and have each one be a separate link to a different spot on a different worksheet. Specifically: I have a worksheet called "Brand Names". On this worksheet i want to create a drop down b...

Passwords
Hi, I have a password field in a database. How do I set it so that a user can only type in 7 characters for a password. and if they type more an error message will appear? Please hi, Daz01 wrote: > Hi, I have a password field in a database. How do I set it so that a > user can only type in 7 characters for a password. and if they type > more an error message will appear? You may use the ValidationRule and ValidationText of the field in the table design view. Setting ValidationRule to Len([YourField])>7) will raise an error in your case. mfG --> stefan <-- ...

Enforce Combo Box Selection
I've got this code in the RowSource property of a combo box called cboLocale. It restricts the choices in Locale based on the users selection in cboSite_ID. SELECT DISTINCT LOCALE, CLIENT_ID FROM tblSales_MTD WHERE (((CLIENT_ID)=[Forms]![frmADM_Assign]![sfrmADM_Assign].[Form]![cboSite_ID])); The problem is, in the On Exit event of cboLocale, I have this code: If IsNull(Me.cboLocale) Then Cancel = True With Me![cboLocale] .Requery .SetFocus .Dropdown End With MsgBox "You must select a locale!", vbCritical, "Error Notice" End If In many cases...

Keep user passwords
Hi! We've just finished installing a new Exchange server and connecting it to a separate DC. We used to have everything on the same server but we'd like to be able to scale our solution better in the future - therefore the new setup. Users are primarily connecting to Exchange by means of RPC over HTTP from clients that are not part of our AD. The old setup allowed users to save passwords if they configured their clients to use NTLM authentication and followed the directions in this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;820281. This worked both for RPC...

Combo boxes #12
I have a combo box in a form that lists all of the countries. I am trying to set it up so that if the user presses the first letter, it goes to the name of the first country with that letter and then if they press the same letter again, it goes to the next country that begins with that letter. I have the first part working, but the second part is not working. I press a letter once and it goes to the first country beginning with that letter, but when I press it again, it doesn't go to the next one. Is there a property to set in the form for that combo box to make it do this? -- LAF ...

How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the password. Is there any way that I can gain access to my worksheet? There are tons of FREE good Excel password 'cracking' tools. Your favorite search engine should get about a gazillion hits on a phrase like "crack excel password" or "excel password cracker". A good one that many report great success with can be found at: http://www.straxx.com/excel/password.html "Laurie" wrote: > I password protected an Excel spreadsheet and now can't remember the > p...

Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help section. You can prevent un authorised access by giving a password to open the workbook itself, so that no one else can open it (Go to Tools, Options and then Security Tab). You can do it there if you have already saved the file, or you can go to "save as" then "Tools" and "General Options" where you can give password. On the other hand you can protect work sheets and ranges for different people by using "Tools" and then "Protection" Tab -- M Imran Buha...

How to protect cells?
I would like to protect a range of cells (A2:D24) with a password for a group of users that would make changes to cells in this range. Then on the same sheet, also protect a range of cells (E2:E24) from everyone but me. Is this possible? Thanks. Mark, Please don't multipost. See the thread in .programming. John "Mark F." <m7829@yahoo.com> wrote in message news:FSzQb.10797$6o4.894@fe2.texas.rr.com... > I would like to protect a range of cells (A2:D24) with a password for a > group of users that would make changes to cells in this range. Then on > the same she...

quick copy worksheet into other sheets in same workbook
I am wanting to copy a worksheet that is set up to show student results, targets and achievements into approximately 150 other worksheets in the same workbook. Is there a quick way of doing this other than copying and pasting? I want formats, colours and column widths etc to stay the same. In other words I want to produce about 150 identical copies of my layout as quickly as possible with the minimum of effort. I am using Excel 2003. Thanks in advance for any help and advice offered Right-click on the worksheet tab and select "Move or Copy", then use the dialog box that appear...

The grow and shrink emphasis option question
Hi I have a question on the use of he grow and shrink emphais option under custom animation. I make an object (an airplane icon) grow to say 150% (i.e. 50% larger) - the take-off drama I them make a motion path that allows my airplane to fly in a NorthWesterly diagonal direction - the journey drama I then shrink my airplane to nomal (actual) size from its grown size - the landing dramslative to the alre my question is when i shrik the airplane icon object is such shrinking calulated relative to the actual normal size or is it calculated relative to the already grown size (i...

Shared Workbook Settings, End User Update Changes Refresh Rate
How can I change the default update change refresh rate on PC's that are accessing a shared file? (currently set for 15 minutes, I need 5 Minutes by default). I know how to change it in the share workbook menu for each session, I need to have it always be 5 minutes so that it won't need to be changed each file opening.... ...

Password
I am working with publisher 2007. I finished my site last Dec. and went to make changes. It is not letting me make changes because it does not like my password. I can not figure out how to go in a reset everything from my provider. Any suggestions. I was also trying to see if I could find web publishing wizard, which doesn't seem to exsist with 2007. Thanks If you are saying you forgot your password then contact the ISP Tech Support and they will reset the password to something like 1 2 3 4 or something other that is very simple. They will also instruct you to change it to somethin...

Passwords #3
Using outlook2002. For some reason, it will not store the password. I have checked the box that says "remember password", but, each time I try to log in. It will ask me for it. Any ideas. I am thinking about recreating the profile for thismailbox. I am a consultant, and my customer doesn't know how (or won't write down what I tell them) to do this. Thanks ...

Protection from copying
I have a workbook with hidden cells that I would like to protect (leaving certain cells visible for input). However, even with password protection on the entire workbook, a user can copy all of the cells into another workbook and view/edit/change all of the cells in my workbook. Is there a way around this? thanks Z, If it's formulas you want hidden, use Format - Cells - Protection - Hidden. Then protect the sheet (Tools - Protection - Protect sheet). If it's data, forget it. Users can copy/paste cells , copy the sheet, take a picture of the workbook with PrtScrn (or with ...

format combo box list
I have a combo box list in a form, I was wondering is there a way to change the color of some of the records listed in the box. Like I want to flag certain records as closed and change the color to red and leave the rest of the list in black font. Thanks Kim Already answered in another newsgroup to which you posted the same question. If you feel you need to post to more than one group (HINT: it's seldom necessary), please have the courtesy to cross-post (send the one message to all groups at once), rather than multi-post (send individual messages to each group). In this way, all ...

Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a user. my client want to know how to enable it. hope for your prompt action. -- Jeremy Ayaay Technical Specialist STRC Only works for SQL 2005. If you client wants to use a beta database server... "Jher" wrote: > I'm curious why are the Change Password Next Login, Enforce Password Policy > and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a > user. my client want to know how to enab...

Sent mail
I wrote about this problem a long time ago. I am uisng Outlook 2007 under Vista Home Premium. I had a problem and reinstalled or repaired Office using the CD, following all the instructions. Every since, whenever I go to send _one_ e-mail, I see in the lower right hand corner that two are sent. Now two e-mails are not actually sent, but the program tells me otherwise in that Send\Receive toolbar. This isn't a major problem but is there something I can try. Thanks, DH ...

password prompt when no password is set.
thru a series of unfortunate events I had to reinstall my os and all of my programs. I was using ms money 2000. I have always kept the main *.mny file but lost my backups. When i reinstalled money and tried to open my mny file I get a password prompt. I have never password protected the file and when i tried to run a password recovery program it says "no password set". I do have older backups of this file but they are too old to be of much use. But i am able to access them. any suggestions would be appreciated. Thanks BRC The password prompt often appears when you open a dataset m...

Network password #9
I don't use passwords and now i am prompted to enter a network password or my computer will not connect to email account. Any thoughts If you are still having problems after applying both the SP 1 & 2 patches, then see if this article addresses your problemL OL2002: The Save Password Setting Is Not Saved When You Connect to a POP3 Server http://support.microsoft.com/default.aspx?scid=kb;en-us;290684 --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal accoun...

assemble excel workbook
Excel Folks: I'd like to asemble several excel worksheets and/or workbooks into a single workbook. Is there a quicker way to do this than manually cutting and pasting between workbooks? Eg: workbook1 includes sheet a,b, and c wokbook2 includes sheet d,e, and f >> correct incantation occurs << workbook3 includes sheet a,b,c,d,e, and f Similarly, is there a way to import multiple .csv files into a single workbook in one fell swoop? Thanks to anyone who can help! handjive Willie, You can right-click a worksheet tab, and use Move or Copy sheet to get everythi...