Protect Sheets, protect formula, table,

shahravi14

New Member
Joined
Dec 13, 2011
Messages
4
Hey I have a sheet with my data arranged in several tables in the same sheet. My tables have some cells with formulae and some other cells which is required to be keyed in the by the user. I need to protect the cells with formulae from being accidently manupulated by the user. For this is changed these cell properties from "Format Cell" Option as "Locked Cell".
But my real problem starts now, if I protect the sheet in the normal way, the formating of formulae cells works but at the same time it does not allow me to automatically extend my table as I type (or hit a TAB in the last Bottom Right-Cell in the table) below the last entry in the table.

If any one can let me know how to solve this problem.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

BenMiller

Well-known Member
Joined
Nov 17, 2011
Messages
1,961
Office Version
  1. 365
Platform
  1. Windows
Part of locking sheets means you cannot resize objects. What version of Excel are you using?
 

BenMiller

Well-known Member
Joined
Nov 17, 2011
Messages
1,961
Office Version
  1. 365
Platform
  1. Windows
I'm not familiar with 2007, but I know that in 2010, when you lock a sheet, a list of about twenty options comes up and you can select which permissions you want to give locked users. Enable them to resize/insert objects and they should be fine ...
 

Forum statistics

Threads
1,136,969
Messages
5,678,890
Members
419,787
Latest member
juanam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top