paste locked cells and unlocked cells in protected sheet

A

angeline

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/com...dg=microsoft.public.excel.worksheet.functions
 
D

Dave Peterson

Wouldn't that defeat the purpose of locking the cells on a protected sheet--to
stop changes to those cells?
 
A

angeline

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

Dave Peterson

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

angeline

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 ?
 
D

Dave Peterson

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

romelsb

Hi angeline.....are the row you re going to insert will contain the
formulated properties of the support or just constant values ?
 
A

angeline

formulated properties of the support

romelsb said:
Hi angeline.....are the row you re going to insert will contain the
formulated properties of the support or just constant values ?
 
R

romelsb

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

angeline

yes, please

romelsb said:
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...
 
R

romelsb

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

romelsb

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top