Password protecting certain worksheets in a file

How do I set passwords to protect just certain worksheets 
in a file?
0
anonymous (74719)
3/29/2005 5:48:17 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
482 Views

Similar Articles

[PageSpeed] 29

If you mean worksheet passwords, one way:

    Public Sub ProtectSomeButNotAll()
        Const sPWORD As String = "drowwsap"
        Dim vSheets As Variant
        Dim i As Long
        vSheets = Array("Sheet1", "Sheet3", "Sheet5")
        For i = LBound(vSheets) To UBound(vSheets)
            Worksheets(vSheets(i)).Protect sPWORD
        Next i
    End Sub


In article <071001c53487$7cdd3bb0$a601280a@phx.gbl>,
 "Mike" <anonymous@discussions.microsoft.com> wrote:

> How do I set passwords to protect just certain worksheets 
> in a file?
0
jemcgimpsey (6723)
3/30/2005 2:53:32 AM
Reply:

Similar Artilces:

Why are my excel worksheet columns are Numbered not Alpha
My excel worksheet columns are numbered not alpha. What did I do? How can I change back to numbers Hi Paula, Try: Tools | Options | General Tab | deselect 'R1C1 reference style | ok --- Regards, Norman "Paula" <Paula@discussions.microsoft.com> wrote in message news:BD09BE8B-EDCB-4E91-8EBC-A98049B97A35@microsoft.com... > My excel worksheet columns are numbered not alpha. What did I do? How can > I > change back to numbers You've probably set the R1C1 referencing style. Go to Tools>Options> then selecet the General Tab and uncheck the R1C1...

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...

File opens when Excel opens
Hi, I used an excel file to import contacts into outlook. Now everytime I open Excel, Excel opens to a file called contacts, which is the file I used to import into Outlook. The data is all garbled. What I want to do is to eliminate this file from being opened and have Excel open to a clean workbook called Book1. Can anyone help? Thanks, Chuck hi, The only way that could happen is for contacts be in the xl start folder. remove it form the start folder. where is that? varies but.. c:\program files\office\office\xlstart\ try exploring around the above path. got to be there somewh...

SQL Server Job with file attachment
Hi All, This is SQL Server 2005. I dont know whether its possible or not. i thought will post here. Am running a sql server job schedule to run, which will send mail to recipients with file attachment using msdb.dbo.sp_send_dbmail. The file attachment is just a single file. its running fine now. Now instead of attaching a single file, can i attach the contents of a folder using msdb.dbo.sp_send_dbmail with a SQL Server Job. Thanks, Arun. "Arun" <Arun@discussions.microsoft.com> wrote in message news:BF1BBE1B-3165-4CBA-90E2-AD11CA6B280C@microsoft....

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....

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...

Stubborn Misplaced File
Recently I attempted to backup my Outlook Express using the Windows NT Backup Utility and when I tried to restore the files to the new directory they did not properly restore to the correct location and when I try to delete the misplaced folder it will not allow me to, it gives the following message: X Cannot delete Outlook Express: The file name you specified is not valid or to long. Specify a different file name. It is located in the following location: C:\Documents and Settings\Compaq_Administrator\Local Settings\Application Data\Identities\{D190EE07-1887-45...

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 <-- ...

Block Exchange2000 from sending to certain email addresses
As external clients unsubscribe to email messages sent to them we need to be able to stop our users from sending to that email address in the future. Is there a way to restrict this in Exchange2000. I remember 5.5 had a place for this but I have not found one in Exchange2000. Any help would be appreciated. ...

How do I import e-mail files into Microsoft Publisher 2003?
I receive files thru the internet that I need to get into publisher and change the size, or add data. How do I save them to get them into Publisher? How do I get Word files into Publisher for editing? Thank You Copy/Paste. -- Don Vancouver, USA "Publisher Fan" <Publisher Fan@discussions.microsoft.com> wrote in message news:94B237A1-C5C9-4E51-9AAF-37DC119EFBB2@microsoft.com... >I receive files thru the internet that I need to get into publisher and > change the size, or add data. How do I save them to get them into > Publisher? > How do I get Word files...

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...

how do I import a Quottro Pro 10 notebook file (.qpw) into Excel
I would like to import my worksheets and notebooks (.qpw) that I developed in Corel Quottro Pro 10 into excel 2003. Thank you in advance for your help and information. MARK ...

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...

Excel opens two worksheets instead of one
I have Office 2007 and recently upgraded to Windows 7. When I open an existing document in Excel, sometimes (about 50% of the time) it opens a second blank worksheet along with it. Word does this also. Is there a way to fix this? -- Thank you ...

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...

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...

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 ...

File Size #4
I have several workbooks linked to one autofeed. Most of the workbooks are responding fine, but I have one workbook that significantly increases in size every time it's saved; even when we've not made any changes. Though it contains the same amount of data as a similar workbook, it is now 5 times the size of the others. Is there any way to quickly troubleshoot the problem? I've gone into File, Edit, Links as well as re-linked several pages to see if there was a problem in the way it was set-up originally and so far nothing has worked. I've even removed information only to ...

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 ...

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...

why can't I place the cursor directly on certain cells?
when I am on Sheet2!A1 and I try to enter a formula such as =Sheet1!C4, I find that I cannot point directly to Sheet1!C4; I need to go around and around until I find the first cell in Sheet1 that will accept the cursor; and then I can finally land on C4 by using the keyboard arrows. What causes that and how can I prevent it? KG Is the Sheet2 protected and some cells locked for selection? Check out Tools>Protection. Is Unprotect Sheet available for selection? If so, click on it. You may have to supply a password. Gord Dibben Excel MVP On Mon, 31 Jan 2005 11:59:03 -0800, "KG...

Sending a publisher file as an email attachment
When sending a publisher file as an email attachment and is opened, it does not look like the original. Any suggestions why and how to fix it? Thanks El wrote: > When sending a publisher file as an email attachment and is opened, it does > not look like the original. Any suggestions why and how to fix it? Thanks Different fonts are installed on different computers. Create a PDF and send that instead. -- Ed Bennett - MVP Microsoft Publisher http://ed.mvps.org Ed, Its not just the fonts, words are added, hyphens are added, and graphics are upside down. Any other thoughts? &quo...

File Formate
I have five Excel files which contain the records of my previous 4 years Business matters. Suddenly yesterday when I opned one of my files I received the following messege. --------------------------------------- The file is not in recognizable formate. if you know the file is from another program which is incompatible with Microsoft Excel, click Cancel, then open the file in its original application. If you want to open the file later in Microsoft Excel, save it in a format that is compatible, such as text format. If you suspect the file is damaged, click help for more information about...