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.
m7829
excel.misc
78881 articles. 
5 followers.
7 Replies
984 Views
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 sheet, also protect a range of cells (E2:E24) from everyone but > me. Is this possible? > > Thanks. > >
jwilson"John Wilson" <jwilson@optonline.net> wrote in message news:usTa54r4DHA.1664@TK2MSFTNGP11.phx.gbl... > Mark, > > Please don't multipost. > See the thread in .programming. > > John > Generally it's considered bad netiquette to "cross-post" not multi-post. I don't usually do that but I need help with this problem quickly.
I think you got that backwards. I think most people would rather look at the header and see that it was cross-posted (multiple groups at once). Most(?) newsreader software will reply to all the groups so that work won't be duplicated. If you multipost (multiple posts with the same content posted multiple times), there's no indication that others have worked on a response. It wastes time for the (2nd thru xxth) responders. And it means you have to check multiple spots for responses. "Mark F." wrote: > > "John Wilson" <jwilson@optonline.net> wrote in message > news:usTa54r4DHA.1664@TK2MSFTNGP11.phx.gbl... > > Mark, > > > > Please don't multipost. > > See the thread in .programming. > > > > John > > > > Generally it's considered bad netiquette to "cross-post" not multi-post. > I don't usually do that but I need help with this problem quickly. -- Dave Peterson ec35720@msn.com
ec35720Whatever
Mark, > Whatever Ya' know when people offer their help out of the goodness of their hearts, "whatever" isn't an appropriate response. I don't know if Dave (or the other MVP's) have a blacklist, but if they do, I certainly wouldn't want to be on it. The original intent of my post here and in .worksheet.functions was to consolidate your multipost into just one thread in one ng. The regulars read all three of the major ones anyway so it really doesn't matter which one you post to. Soooo...in summary.... You wasted your time posting to three different groups. You wasted your time again by having to come back to ..worksheet.functions and complain that you "still don't have a viable solution to your problem!" Then you wasted your time having to come to this ng, read the posts and insult Dave with your "Whatever" Then you went to .programming to discover that Norman had actually given you a "viable solution" to your problem. I can almost guarantee that if you hadn't multiposted, you'd have had your answer sooner (and wasted a lot less of your time, my time and the others that read these ng's). None of us work for MS and none of us get paid for participating in these ng's. We do it because we enjoy helping others. Keep that in mind the next time you post. I'm glad you got an answer from Norman that worked for you. John "Mark F." <m7829@yahoo.com> wrote in message news:hs%Qb.13164$7D.2073@fe2.texas.rr.com... > Whatever > >
Hi John! I don't think any of the regulars keep a blacklist but if I'd seen the "whatever" to Dave, I certainly would not have answered this post. There might be a "whitelist" with grateful "customers" or those struggling receiving endless patient help. Whatever! I blame Jerry Springer. -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
njharkerIt may not have helped the OP, but I bet that there are lurkers who read these messages. (I know I lurked before posting.) And maybe it helped someone else who saw that fragmenting the responses doesn't usually help the original poster. John Wilson wrote: > > Mark, > > > Whatever > Ya' know when people offer their help out of the goodness of their > hearts, "whatever" isn't an appropriate response. > I don't know if Dave (or the other MVP's) have a blacklist, but if they > do, I certainly wouldn't want to be on it. > > The original intent of my post here and in .worksheet.functions was > to consolidate your multipost into just one thread in one ng. > The regulars read all three of the major ones anyway so it > really doesn't matter which one you post to. > > Soooo...in summary.... > You wasted your time posting to three different groups. > You wasted your time again by having to come back to > .worksheet.functions and complain that you "still don't > have a viable solution to your problem!" > Then you wasted your time having to come to this ng, > read the posts and insult Dave with your "Whatever" > Then you went to .programming to discover that Norman > had actually given you a "viable solution" to your problem. > > I can almost guarantee that if you hadn't multiposted, > you'd have had your answer sooner (and wasted a lot less > of your time, my time and the others that read these ng's). > > None of us work for MS and none of us get paid for > participating in these ng's. We do it because we enjoy > helping others. Keep that in mind the next time you post. > > I'm glad you got an answer from Norman that worked for you. > > John > > "Mark F." <m7829@yahoo.com> wrote in message > news:hs%Qb.13164$7D.2073@fe2.texas.rr.com... > > Whatever > > > > -- Dave Peterson ec35720@msn.com
Similar Artilces:
Quicken Password protected
I just got Money 2004 Deluxe, I am trying to import my data from Quicken and the program says there is a password for my quicken account that is required, but I never had a password. No way to get past this. Any ideas? If your data file is Q04, Money04 can only deal with Q03 or older. Otherwise, who knows? "Stephen Weiss" <stephenaweiss@comcast.net> wrote in message news:012f01c3cb22$9a957ac0$a101280a@phx.gbl... > I just got Money 2004 Deluxe, I am trying to import my > data from Quicken and the program says there is a password > for my quicken account that is req...
linking cells in a column (result) to cells in a row (source)
MS XP Pro / Excel 2007: Good day all. I have data in two consecutive rows. The 1st one is text and the second contains formulae which results in values. (Call these the "source") On another sheet in the same workbook I have two columns (Call these the destination) which need to be linked to the source rows if value (other than zero) is present in the 2nd source row. There could be zero value or blank cells within the source rows. I need code to sequentially seek values (other than zero) in the cells in the 2nd row of the source and when found, the next available cell ...
protecting outlined data
I want to be able to use the expand/collapse function in outlines when the worksheet is protected. Copy this macro in a normal module It will run automatic when you open the workbook You can also use the workbook open event Sub auto_open() With Worksheets("sheet1") .Protect Password:="rbelecki", userinterfaceonly:=True .EnableOutlining = True End With End Sub Look in the VBA help for more information about protect(userinterfaceonly) -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "rbelecki" <rbelecki@l...
Password Protect Outlook #2
I work in an offcie environment and sometimes have to leave my PC unattended for just a few minutes. Unfortunately some confidential emails have been read by my staff and I need a way of safeguarding them other than turning off the PC, is there any way I can password protect access into my Outlook 2000, so all I do is close Outlook. (Sorry still operating under W95) Many thanks You can set a password on a Personal Folders File. If the folder list isn't visible in Outlook, click View | Folder List. Right-click the root folder (usually "Personal Folders" or "Outlook T...
Adding cells with a particular comment
Hi all, is there any simple to add all cells in a row which have a particular comment without using macro. pls help. Regards, NC HI, Use the SumIF function -- anurag. ----------------------------------------------------------------------- anurag.d's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=895 View this thread: http://www.excelforum.com/showthread.php?threadid=31476 well i can use it for particular values but how to use it with comments. My problem is a particular comment for e.g "reject" or "accept" ia added to that cell, & ...
Cell ref is it possibile to calculate / change this in a formula
Any SUPER USERS uot there? I am trying to construct a formula where I need to copy it down 6500+ rows but I need one of the cell refs to be calculated in sted of having its row number to raise by one for each row copied. sample, Normel coping: =IF(AND(F25<=201012,F25<>$F$1),B25,'MASTER tot'!C25) =IF(AND(F26<=201012,F26<>$F$1),B26,'MASTER tot'!C26) What I am trying to get: =IF(AND(F25<=201012,F25<>$F$1),B25,'MASTER tot'!C25) =IF(AND(F26<=201012,F26<>$F$1),B26,'MASTER tot'!C16) For every line the for...
Password protection on split database
I have a database which is split into front end and back end. The front end is password protected but the backend isn't Is it possible to protect both with the same password? I've tried protecting the backend with a password but when I open the front end it can't "see" the backend. Any ideas? Thanks Tony Put a password on the backend, then, after opening the front-end, use the Linked Table Manager to update the links (just like you would if you had moved the backend). You should be prompted for the 'missing' password during this process. You should only...
How to protect 2. axis in an Excel Chart to stay if data changes
A Pivot table is created on Tab1 in an Excel workbook. On Tab2 there is a Line Chart created with data from Tab 1 using 2 axis. If data in Tab1 change the 2nd axis on Tab 2 disappears, jumps ober and overrules axis 1. How can I protect chart area with 2 axis being able to change referring data in the pivot table. ...
pivot table empty cell
I need to have an empty cell be in the pivot table. I have multiple pivot tables I have generated for a report. I have created a worksheet that reads the data from the pivot table (so it looks nicer). I have tried to check the box in options that says to put a 0 or another symbol (*) in an empty cell and it doesn't work. I want people to be able to input their own data and refresh the pivot table. If I have four response options (sometimes, always, never, usually) and the new data does not have data for one of the options then the table that reads the data gets messed up with its numb...
Protection
Hi everyone OK my problem is I am using an offie computer that everyone has access to and we cannot - and do not want to - change this. Is there a way that I can put a password for my profile on Microsoft outlook so that no one can read the new AND the old messages found in my inbox? You can put a password on your PST file, presuming you use a PST file... Emad Kamel wrote: > Hi everyone, > OK my problem is I am using an offie computer that everyone has > access to and we cannot - and do not want to - change this. Is there > a way that I can put a password for my profile on Micr...
limit no of characters in cell
How can I limit the number of charaters (including spaces) in a cell to 48? Additionally, I'm not sure if this is possible, say it applied to cell A1, once 48 characters are reached, it will then automatically drop down to the cell below to A2 and do the same again. thanks -- rocket0612 ------------------------------------------------------------------------ rocket0612's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19492 View this thread: http://www.excelforum.com/showthread.php?threadid=375572 Try validation from the Data menu, and select text length...
IN CELL CALCULATIONS
DONT KNOW IF I CAN DO THIS BUT.. IM TRYING TO ADD A FORMULA INTO A CELL TO SPLIT THE NUMBER I PUT INTO THAT PERTICULAR CELL, FOR INSTANCE IF I ENTER THE NUMBER 2 INTO A CELL I NEED IT TO THEN SPLIT THAT NUMBER INTO FRACTIONS, THIS IS SO I CAN CALCULATE MY FOOD STOCK, AS IF I NEED TO CHECK STEAKS FOR INSTANCE, I MAY HAVE ONLY SOLD HALF FOR A PERTICULUR MEAL SO IF I ENTER THAT 2 HAVE BEEN SOLD, I NEED THE CELL TO CALCULATE THAT IN TOTAL IVE ONLY SOLD ONE WHOLE STEAK... Hi! It sounds to me as if you need to settle on a safe system of units. Fo example, if the smallest unit of steak is half a s...
CANNOT PROTECT
Trying to password and read only protect a Microsoft Word docuement that is embedded in Excel. When I open the "protected" document, the read-only prompt does not appear...and I can still make changes and close the docuement. HELP! Try this: create the document directly in word, protect it and save it to disk. Then copy the text you want and past it special as an OLE object in excel Peter ...
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...
Protecting a Worksheet
Does anybody know how to protect a workbook so that a user CANNOT unhide a sheet, CANNOT add rows to the viewable sheet, CANNOT alter locked cells, but CAN add text to a comments column which will expand and Wrap text as the comments increase in size? I understand how to protect/unprotect locked cells, but I cannot find the right combination for the above functionality. Is it even possible? Any help is greatly appreciated. Jeff When a _Workbook_ is protected (Tools, Protection, Protect Workbook, Structure) sheets cannot be unhidden. When a _Worksheet_ is protected locked cells ca...
How to navigate within a formula without changing cell references?
I have the following function in G20: =IF(C20>0,F20,"") I need to replace the second parameter (F20), with another IF statement. =IF(C20>0,IF(F20<>"",F20,"Error"),"") I go to G20 and press F2 to edit the formula. I move the cursor to just before the "F20" using the arrow keys and start typing in the new IF statement. When I have it entered, I need to move the cursor over the old F20 to finish the new IF statement, but Excel takes the arrow keys to mean I want to reference an adjacent cell. How can I get Excel to interpre...
Count Cells Within 10 of a Cell Value
I need a formula that calculates how many out of a range of cells are within 10 of another cell. For instance, I have cells F3 through U3. I want to know how many of them are either 10 above or 10 below the value in cell V3. If cell V3 equals 20, than I want to know how many are between 10 and 20 and how many are between 20 and 30. Ideally, this would be in the same formula but two seperate formulas is also acceptable. Look in the help index for SUMIF. You can combine -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Missbrooke06" &...
stopping pasted text deliminate across multiple cells
When pasting text that contains back slashes, text is split into multiple cells using the back slash as a deliminator, this occurs automatically and I wish to stop it. Pasting as text or unicode text via paste special makes no difference. Example text 'C:\Program Files\Common Files\Microsoft Shared' splits into 4 cells in a row and the back slashs removed Using Excel 2003 SP1 Paul, Did you do a Text to Columns with the back slash as the delimiter ? look at this: -- Regards, Juan Pablo Gonz�lez Excel MVP "Paul from NZ" <Paul from NZ@discussions.microsoft.com> w...
How do I pass series data x-value range to a chart from a cell?
I have a series on a line chart (x-values "=Sheet1!$A$1:$A$10"). I also have two worksheet cells (B1 & B2) that contain the start and end date for the x-axis of the chart. I want to be able to link the chart series data to the start and end date values so that the chart automatically adjusts when I change the dates in the worksheet cells. I can create a string or address for the x-values but how do I do not know how to pass this to the chart series?? I know I can do this using a macro, but I want to do it without macros so that friends who use MicrosoftCharts (the cheap, n...
Password protected sheet access
I have a spreadsheet protected with a unknown password. How do I access this sheet? Ps: the "read only" option is not available. Thanks, Rivane. Hi Rivane Is this the password for opening the file, or the one for unlocking locked cells in the already open sheet ? Best wishes Harald Excel MVP Followup to newsgroup only please. "Rivane Cardim" <rivane.cardim@exxonmobil.com> wrote in message news:0a8801c35dae$a03275a0$a301280a@phx.gbl... > I have a spreadsheet protected with a unknown password. > How do I access this sheet? > > Ps: the "read only...
Formula omits adjacent cells: ignore a whole row at once?
Allowing space to add further rows in a spreadsheet gives me a whole row of totals where the formula is tagged as 'formula omits adjacent cells'. How can I get the thing to ignore the lot at once rather than having to open all the drop down dialogues one at a time? Cheers, S On Jul 18, 8:19 am, "spamlet" <spam.mores...@invalid.invalid> wrote: > Allowing space to add further rows in a spreadsheet gives me a whole row of > totals where the formula is tagged as 'formula omits adjacent cells'. How > can I get the thing to ignore the lot at once r...
How to Activate "Show all" in a Protected Shared Workbook
Hi, I created a protected and shared workbook in Excel 2003 ,the default Filter Option is "Auto Filter" how can I use the "Show All" in Filtering.? even I unchecked the "Filter Settings" in "Tools-> Share Workbook -> Advanced -> Include Personal View " but it did not work. Thanks. You can't. If the workbook were not shared, then you could create your own macro that unprotects the worksheet, does the showall and reprotects the worksheet. But with the workbook shared, you can't change the protection of a shee...
Count of text in cells
I have problem to solve,I have a column with office. The text in the Office cells with be, Office 1@810@NT but I now have a new columm with text in the following format:Test The Cell - Employment cells can contain mutiple values, Test The Cell - Education;Test The Cell - Employment;Test The Cell - Health . These values are separated by a ; NOt only do I need to count each occurance, but I then need to have a count of each one. I can have these values referred to in a cell if that makes it easier. Sorry if I have not been clear Submitted via EggHeadCafe - Software Developer Portal of Ch...
How do I merge 2 cells for ex. DE (1 cell) & 01234 (2 cell) into .
Hi, Day... First - put just a hint of what you want help on in the Subject line, and then explain in full in the message. It truncates in the Subject. This is what I think you want: Cell A1 = DE, Cell B1 = 01234. In Cell C1, enter =A1&B1. If you want a space between them, it's =A!&" "&B1 HTH, (Hope This Helps) Carole O "DaysofSomer" wrote: > ...
I just got Money 2004 Deluxe, I am trying to import my data from Quicken and the program says there is a password for my quicken account that is required, but I never had a password. No way to get past this. Any ideas? If your data file is Q04, Money04 can only deal with Q03 or older. Otherwise, who knows? "Stephen Weiss" <stephenaweiss@comcast.net> wrote in message news:012f01c3cb22$9a957ac0$a101280a@phx.gbl... > I just got Money 2004 Deluxe, I am trying to import my > data from Quicken and the program says there is a password > for my quicken account that is req...
linking cells in a column (result) to cells in a row (source)
MS XP Pro / Excel 2007: Good day all. I have data in two consecutive rows. The 1st one is text and the second contains formulae which results in values. (Call these the "source") On another sheet in the same workbook I have two columns (Call these the destination) which need to be linked to the source rows if value (other than zero) is present in the 2nd source row. There could be zero value or blank cells within the source rows. I need code to sequentially seek values (other than zero) in the cells in the 2nd row of the source and when found, the next available cell ...
protecting outlined data
I want to be able to use the expand/collapse function in outlines when the worksheet is protected. Copy this macro in a normal module It will run automatic when you open the workbook You can also use the workbook open event Sub auto_open() With Worksheets("sheet1") .Protect Password:="rbelecki", userinterfaceonly:=True .EnableOutlining = True End With End Sub Look in the VBA help for more information about protect(userinterfaceonly) -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "rbelecki" <rbelecki@l...
Password Protect Outlook #2
I work in an offcie environment and sometimes have to leave my PC unattended for just a few minutes. Unfortunately some confidential emails have been read by my staff and I need a way of safeguarding them other than turning off the PC, is there any way I can password protect access into my Outlook 2000, so all I do is close Outlook. (Sorry still operating under W95) Many thanks You can set a password on a Personal Folders File. If the folder list isn't visible in Outlook, click View | Folder List. Right-click the root folder (usually "Personal Folders" or "Outlook T...
Adding cells with a particular comment
Hi all, is there any simple to add all cells in a row which have a particular comment without using macro. pls help. Regards, NC HI, Use the SumIF function -- anurag. ----------------------------------------------------------------------- anurag.d's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=895 View this thread: http://www.excelforum.com/showthread.php?threadid=31476 well i can use it for particular values but how to use it with comments. My problem is a particular comment for e.g "reject" or "accept" ia added to that cell, & ...
Cell ref is it possibile to calculate / change this in a formula
Any SUPER USERS uot there? I am trying to construct a formula where I need to copy it down 6500+ rows but I need one of the cell refs to be calculated in sted of having its row number to raise by one for each row copied. sample, Normel coping: =IF(AND(F25<=201012,F25<>$F$1),B25,'MASTER tot'!C25) =IF(AND(F26<=201012,F26<>$F$1),B26,'MASTER tot'!C26) What I am trying to get: =IF(AND(F25<=201012,F25<>$F$1),B25,'MASTER tot'!C25) =IF(AND(F26<=201012,F26<>$F$1),B26,'MASTER tot'!C16) For every line the for...
Password protection on split database
I have a database which is split into front end and back end. The front end is password protected but the backend isn't Is it possible to protect both with the same password? I've tried protecting the backend with a password but when I open the front end it can't "see" the backend. Any ideas? Thanks Tony Put a password on the backend, then, after opening the front-end, use the Linked Table Manager to update the links (just like you would if you had moved the backend). You should be prompted for the 'missing' password during this process. You should only...
How to protect 2. axis in an Excel Chart to stay if data changes
A Pivot table is created on Tab1 in an Excel workbook. On Tab2 there is a Line Chart created with data from Tab 1 using 2 axis. If data in Tab1 change the 2nd axis on Tab 2 disappears, jumps ober and overrules axis 1. How can I protect chart area with 2 axis being able to change referring data in the pivot table. ...
pivot table empty cell
I need to have an empty cell be in the pivot table. I have multiple pivot tables I have generated for a report. I have created a worksheet that reads the data from the pivot table (so it looks nicer). I have tried to check the box in options that says to put a 0 or another symbol (*) in an empty cell and it doesn't work. I want people to be able to input their own data and refresh the pivot table. If I have four response options (sometimes, always, never, usually) and the new data does not have data for one of the options then the table that reads the data gets messed up with its numb...
Protection
Hi everyone OK my problem is I am using an offie computer that everyone has access to and we cannot - and do not want to - change this. Is there a way that I can put a password for my profile on Microsoft outlook so that no one can read the new AND the old messages found in my inbox? You can put a password on your PST file, presuming you use a PST file... Emad Kamel wrote: > Hi everyone, > OK my problem is I am using an offie computer that everyone has > access to and we cannot - and do not want to - change this. Is there > a way that I can put a password for my profile on Micr...
limit no of characters in cell
How can I limit the number of charaters (including spaces) in a cell to 48? Additionally, I'm not sure if this is possible, say it applied to cell A1, once 48 characters are reached, it will then automatically drop down to the cell below to A2 and do the same again. thanks -- rocket0612 ------------------------------------------------------------------------ rocket0612's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19492 View this thread: http://www.excelforum.com/showthread.php?threadid=375572 Try validation from the Data menu, and select text length...
IN CELL CALCULATIONS
DONT KNOW IF I CAN DO THIS BUT.. IM TRYING TO ADD A FORMULA INTO A CELL TO SPLIT THE NUMBER I PUT INTO THAT PERTICULAR CELL, FOR INSTANCE IF I ENTER THE NUMBER 2 INTO A CELL I NEED IT TO THEN SPLIT THAT NUMBER INTO FRACTIONS, THIS IS SO I CAN CALCULATE MY FOOD STOCK, AS IF I NEED TO CHECK STEAKS FOR INSTANCE, I MAY HAVE ONLY SOLD HALF FOR A PERTICULUR MEAL SO IF I ENTER THAT 2 HAVE BEEN SOLD, I NEED THE CELL TO CALCULATE THAT IN TOTAL IVE ONLY SOLD ONE WHOLE STEAK... Hi! It sounds to me as if you need to settle on a safe system of units. Fo example, if the smallest unit of steak is half a s...
CANNOT PROTECT
Trying to password and read only protect a Microsoft Word docuement that is embedded in Excel. When I open the "protected" document, the read-only prompt does not appear...and I can still make changes and close the docuement. HELP! Try this: create the document directly in word, protect it and save it to disk. Then copy the text you want and past it special as an OLE object in excel Peter ...
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...
Protecting a Worksheet
Does anybody know how to protect a workbook so that a user CANNOT unhide a sheet, CANNOT add rows to the viewable sheet, CANNOT alter locked cells, but CAN add text to a comments column which will expand and Wrap text as the comments increase in size? I understand how to protect/unprotect locked cells, but I cannot find the right combination for the above functionality. Is it even possible? Any help is greatly appreciated. Jeff When a _Workbook_ is protected (Tools, Protection, Protect Workbook, Structure) sheets cannot be unhidden. When a _Worksheet_ is protected locked cells ca...
How to navigate within a formula without changing cell references?
I have the following function in G20: =IF(C20>0,F20,"") I need to replace the second parameter (F20), with another IF statement. =IF(C20>0,IF(F20<>"",F20,"Error"),"") I go to G20 and press F2 to edit the formula. I move the cursor to just before the "F20" using the arrow keys and start typing in the new IF statement. When I have it entered, I need to move the cursor over the old F20 to finish the new IF statement, but Excel takes the arrow keys to mean I want to reference an adjacent cell. How can I get Excel to interpre...
Count Cells Within 10 of a Cell Value
I need a formula that calculates how many out of a range of cells are within 10 of another cell. For instance, I have cells F3 through U3. I want to know how many of them are either 10 above or 10 below the value in cell V3. If cell V3 equals 20, than I want to know how many are between 10 and 20 and how many are between 20 and 30. Ideally, this would be in the same formula but two seperate formulas is also acceptable. Look in the help index for SUMIF. You can combine -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Missbrooke06" &...
stopping pasted text deliminate across multiple cells
When pasting text that contains back slashes, text is split into multiple cells using the back slash as a deliminator, this occurs automatically and I wish to stop it. Pasting as text or unicode text via paste special makes no difference. Example text 'C:\Program Files\Common Files\Microsoft Shared' splits into 4 cells in a row and the back slashs removed Using Excel 2003 SP1 Paul, Did you do a Text to Columns with the back slash as the delimiter ? look at this: -- Regards, Juan Pablo Gonz�lez Excel MVP "Paul from NZ" <Paul from NZ@discussions.microsoft.com> w...
How do I pass series data x-value range to a chart from a cell?
I have a series on a line chart (x-values "=Sheet1!$A$1:$A$10"). I also have two worksheet cells (B1 & B2) that contain the start and end date for the x-axis of the chart. I want to be able to link the chart series data to the start and end date values so that the chart automatically adjusts when I change the dates in the worksheet cells. I can create a string or address for the x-values but how do I do not know how to pass this to the chart series?? I know I can do this using a macro, but I want to do it without macros so that friends who use MicrosoftCharts (the cheap, n...
Password protected sheet access
I have a spreadsheet protected with a unknown password. How do I access this sheet? Ps: the "read only" option is not available. Thanks, Rivane. Hi Rivane Is this the password for opening the file, or the one for unlocking locked cells in the already open sheet ? Best wishes Harald Excel MVP Followup to newsgroup only please. "Rivane Cardim" <rivane.cardim@exxonmobil.com> wrote in message news:0a8801c35dae$a03275a0$a301280a@phx.gbl... > I have a spreadsheet protected with a unknown password. > How do I access this sheet? > > Ps: the "read only...
Formula omits adjacent cells: ignore a whole row at once?
Allowing space to add further rows in a spreadsheet gives me a whole row of totals where the formula is tagged as 'formula omits adjacent cells'. How can I get the thing to ignore the lot at once rather than having to open all the drop down dialogues one at a time? Cheers, S On Jul 18, 8:19 am, "spamlet" <spam.mores...@invalid.invalid> wrote: > Allowing space to add further rows in a spreadsheet gives me a whole row of > totals where the formula is tagged as 'formula omits adjacent cells'. How > can I get the thing to ignore the lot at once r...
How to Activate "Show all" in a Protected Shared Workbook
Hi, I created a protected and shared workbook in Excel 2003 ,the default Filter Option is "Auto Filter" how can I use the "Show All" in Filtering.? even I unchecked the "Filter Settings" in "Tools-> Share Workbook -> Advanced -> Include Personal View " but it did not work. Thanks. You can't. If the workbook were not shared, then you could create your own macro that unprotects the worksheet, does the showall and reprotects the worksheet. But with the workbook shared, you can't change the protection of a shee...
Count of text in cells
I have problem to solve,I have a column with office. The text in the Office cells with be, Office 1@810@NT but I now have a new columm with text in the following format:Test The Cell - Employment cells can contain mutiple values, Test The Cell - Education;Test The Cell - Employment;Test The Cell - Health . These values are separated by a ; NOt only do I need to count each occurance, but I then need to have a count of each one. I can have these values referred to in a cell if that makes it easier. Sorry if I have not been clear Submitted via EggHeadCafe - Software Developer Portal of Ch...
How do I merge 2 cells for ex. DE (1 cell) & 01234 (2 cell) into .
Hi, Day... First - put just a hint of what you want help on in the Subject line, and then explain in full in the message. It truncates in the Subject. This is what I think you want: Cell A1 = DE, Cell B1 = 01234. In Cell C1, enter =A1&B1. If you want a space between them, it's =A!&" "&B1 HTH, (Hope This Helps) Carole O "DaysofSomer" wrote: > ...