Excel Allowing users to add rows in protected excel table

Joined
Mar 8, 2013
Messages
2
Reaction score
0
I was wondering if there is a way to let the user add rows to a protected table and still get the formulas in the cells that's supposed to have formulas?

I have a table which is protected and users has access to certain "data entry" cells. One user should have the access to add "records". When the "insert row" option is allowed when protecting sheet, the user is allowed to insert a row but the row is blank (without formulas in cells that does calculation. Is there a way to fix this? Can the user "tab" in the protected sheet and add a row?

I am using Excel 2010

Thanks

Ismaili
 
Joined
Mar 20, 2012
Messages
764
Reaction score
4
After playing around with it a bit, I couldn't find an easy solution for you. I did manage to find an article that may be of use to you, but it's a lot of VBA, so I won't be of much further help. Good Luck!

Link
 
Joined
Mar 8, 2013
Messages
2
Reaction score
0
After playing around with it a bit, I couldn't find an easy solution for you. I did manage to find an article that may be of use to you, but it's a lot of VBA, so I won't be of much further help. Good Luck!

Link
Thanks, alow. I am not good with VBA codes so dont know if that will work for me. But thanks for trying and for the link
 

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