All Answers

I don't understand

Would Copy -> Paste work? Copy will work and in Excel 2003 you can allow inserting rows and columns. Nothing I tried worked either. Which is good for me. We don't want our users moving protected cells around.

Clarification

Yes, I have a need for my clients to be able to copy/paste additional Rows (of a templated Row) so they can log in specific data. However, there are locked cells within that Row to prevent them from altering Formulas. So they are unable to Copy & Paste unless I keep the sheet unprotected, which defeats my purpose.

OK

So far Toms45 has the best idea. The problem with that is your cells referencing the formulas can't be protected. Or at least that's my understanding.

In my trials yesterday with Excel 2003 you can allow "Insert Rows / Insert Columns", but it had to be the whole row/column. I was unable to "Insert copied cells". Maybe MS will have that available in Office 20XX?

Thank you

Unfortunately I am unable to keep cells locked (regardless if a formula resides in the cell) in fear that clients will type in the wrong cells. I realized I still have cells that need to be locked so the tab key will skip over them.

I thank you for your trials & troubleshooting in regards to my dilemna!

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.