Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
Please allow paste locked cells and unlocked cells in protected sheet
---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
Wouldn't that defeat the purpose of locking the cells on a protected sheet--to
stop changes to those cells? angeline wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
I'm a mechanical designer in mechanical field, in a project we have varies
type of support with differents height, I use excel to calculate all the details value and intend to share this worksheet with other. I will only wish to allow user to fill in the support height, the rest will be generate by excel. If I have lots of support , that's mean the user have to copy and paste in a new row, If I protected the work sheet, user are not allow to paste in a new row. That's why I need to paste some locked cells in an protected sheet. "Dave Peterson" wrote: Wouldn't that defeat the purpose of locking the cells on a protected sheet--to stop changes to those cells? angeline wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
But the first time someone pasted their data over your locked cells that contain
your formulas, I bet you'd want excel to stop them. I don't see how excel could support both requirements. But maybe you could provide them some macro that did exactly what you want. angeline wrote: I'm a mechanical designer in mechanical field, in a project we have varies type of support with differents height, I use excel to calculate all the details value and intend to share this worksheet with other. I will only wish to allow user to fill in the support height, the rest will be generate by excel. If I have lots of support , that's mean the user have to copy and paste in a new row, If I protected the work sheet, user are not allow to paste in a new row. That's why I need to paste some locked cells in an protected sheet. "Dave Peterson" wrote: Wouldn't that defeat the purpose of locking the cells on a protected sheet--to stop changes to those cells? angeline wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
I'm not keen in macro, I just know some simple formula like if. else , or..
If I want to write a macro for this situation : anyone who insert a row between the locked and unlocked cells row, the row come with above or below fumula locked or unlocked cells (in protected sheet) How to write and Is it hard to write ? "Dave Peterson" wrote: But the first time someone pasted their data over your locked cells that contain your formulas, I bet you'd want excel to stop them. I don't see how excel could support both requirements. But maybe you could provide them some macro that did exactly what you want. angeline wrote: I'm a mechanical designer in mechanical field, in a project we have varies type of support with differents height, I use excel to calculate all the details value and intend to share this worksheet with other. I will only wish to allow user to fill in the support height, the rest will be generate by excel. If I have lots of support , that's mean the user have to copy and paste in a new row, If I protected the work sheet, user are not allow to paste in a new row. That's why I need to paste some locked cells in an protected sheet. "Dave Peterson" wrote: Wouldn't that defeat the purpose of locking the cells on a protected sheet--to stop changes to those cells? angeline wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
Start by recording a macro when you do it manually.
You'll have to tweak the code--maybe add some extra checks. If you have trouble, post back with your questions. angeline wrote: I'm not keen in macro, I just know some simple formula like if. else , or.. If I want to write a macro for this situation : anyone who insert a row between the locked and unlocked cells row, the row come with above or below fumula locked or unlocked cells (in protected sheet) How to write and Is it hard to write ? "Dave Peterson" wrote: But the first time someone pasted their data over your locked cells that contain your formulas, I bet you'd want excel to stop them. I don't see how excel could support both requirements. But maybe you could provide them some macro that did exactly what you want. angeline wrote: I'm a mechanical designer in mechanical field, in a project we have varies type of support with differents height, I use excel to calculate all the details value and intend to share this worksheet with other. I will only wish to allow user to fill in the support height, the rest will be generate by excel. If I have lots of support , that's mean the user have to copy and paste in a new row, If I protected the work sheet, user are not allow to paste in a new row. That's why I need to paste some locked cells in an protected sheet. "Dave Peterson" wrote: Wouldn't that defeat the purpose of locking the cells on a protected sheet--to stop changes to those cells? angeline wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
Ps...
David McRitchie has some code to insert rows and copy formulas at: http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Dave Peterson wrote: Start by recording a macro when you do it manually. You'll have to tweak the code--maybe add some extra checks. If you have trouble, post back with your questions. angeline wrote: I'm not keen in macro, I just know some simple formula like if. else , or.. If I want to write a macro for this situation : anyone who insert a row between the locked and unlocked cells row, the row come with above or below fumula locked or unlocked cells (in protected sheet) How to write and Is it hard to write ? "Dave Peterson" wrote: But the first time someone pasted their data over your locked cells that contain your formulas, I bet you'd want excel to stop them. I don't see how excel could support both requirements. But maybe you could provide them some macro that did exactly what you want. angeline wrote: I'm a mechanical designer in mechanical field, in a project we have varies type of support with differents height, I use excel to calculate all the details value and intend to share this worksheet with other. I will only wish to allow user to fill in the support height, the rest will be generate by excel. If I have lots of support , that's mean the user have to copy and paste in a new row, If I protected the work sheet, user are not allow to paste in a new row. That's why I need to paste some locked cells in an protected sheet. "Dave Peterson" wrote: Wouldn't that defeat the purpose of locking the cells on a protected sheet--to stop changes to those cells? angeline wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
Thanks for ur great help, will try it later.
"angeline" wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
Hi angeline.....are the row you re going to insert will contain the
formulated properties of the support or just constant values ? "angeline" wrote: Thanks for ur great help, will try it later. "angeline" wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
formulated properties of the support
"romelsb" wrote: Hi angeline.....are the row you re going to insert will contain the formulated properties of the support or just constant values ? "angeline" wrote: Thanks for ur great help, will try it later. "angeline" wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
Angeline J.....I got a sheet for steel support and beams - basics - with
varying end restraints - wanna try this one sheet good for as many steel sections you will prefer...Input length alone and steel index number... "angeline" wrote: formulated properties of the support "romelsb" wrote: Hi angeline.....are the row you re going to insert will contain the formulated properties of the support or just constant values ? "angeline" wrote: Thanks for ur great help, will try it later. "angeline" wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
yes, please
"romelsb" wrote: Angeline J.....I got a sheet for steel support and beams - basics - with varying end restraints - wanna try this one sheet good for as many steel sections you will prefer...Input length alone and steel index number... "angeline" wrote: formulated properties of the support "romelsb" wrote: Hi angeline.....are the row you re going to insert will contain the formulated properties of the support or just constant values ? "angeline" wrote: Thanks for ur great help, will try it later. "angeline" wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
how can i send it...can u mail me on "
-- "Bright minds are blessed to those who share them.."-rsb. "angeline" wrote: yes, please "romelsb" wrote: Angeline J.....I got a sheet for steel support and beams - basics - with varying end restraints - wanna try this one sheet good for as many steel sections you will prefer...Input length alone and steel index number... "angeline" wrote: formulated properties of the support "romelsb" wrote: Hi angeline.....are the row you re going to insert will contain the formulated properties of the support or just constant values ? "angeline" wrote: Thanks for ur great help, will try it later. "angeline" wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
Hi, i try to attached the file but when i am sending it, something pop-up in
the window and have message in unreadable character, maybe chinese....are you chinese...where do you live....i hope you have another email address...keep in touch.. "angeline" wrote: Hi, the mail sent to you is bounce back. Can you email to ? "romelsb" wrote: how can i send it...can u mail me on " -- "Bright minds are blessed to those who share them.."-rsb. "angeline" wrote: yes, please "romelsb" wrote: Angeline J.....I got a sheet for steel support and beams - basics - with varying end restraints - wanna try this one sheet good for as many steel sections you will prefer...Input length alone and steel index number... "angeline" wrote: formulated properties of the support "romelsb" wrote: Hi angeline.....are the row you re going to insert will contain the formulated properties of the support or just constant values ? "angeline" wrote: Thanks for ur great help, will try it later. "angeline" wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste locked cells and unlocked cells in protected sheet
Sorry for waiting....I just sent the workbook today successfully thru my
other mail address... try to roam around its formulation and use the auditing toolbars..... more power "angeline" wrote: Hi, the mail sent to you is bounce back. Can you email to ? "romelsb" wrote: how can i send it...can u mail me on " -- "Bright minds are blessed to those who share them.."-rsb. "angeline" wrote: yes, please "romelsb" wrote: Angeline J.....I got a sheet for steel support and beams - basics - with varying end restraints - wanna try this one sheet good for as many steel sections you will prefer...Input length alone and steel index number... "angeline" wrote: formulated properties of the support "romelsb" wrote: Hi angeline.....are the row you re going to insert will contain the formulated properties of the support or just constant values ? "angeline" wrote: Thanks for ur great help, will try it later. "angeline" wrote: Please allow paste locked cells and unlocked cells in protected sheet ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protected sheet arrow keys not working on unlocked cells | Excel Discussion (Misc queries) | |||
Able to overwrite locked cell in protected sheet | Excel Discussion (Misc queries) | |||
Still can select locked cells in protected sheet | New Users to Excel | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
move between unlocked cells on protected sheet | Excel Discussion (Misc queries) |