Locking Cell Width

pablof

New Member
Joined
Aug 27, 2015
Messages
6
Hi there,

I want to lock the structure of my workbook to prevent users from amending the size or columns, but I still need the users to be able to enter data into the sheet and delete rows when they are finished with.

I have tried protecting the sheet, which stops the users being able to alter the size, but they then can't enter and amend data either.

Any thoughts?
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
1,295
Office Version
  1. 2013
Platform
  1. Windows
Have the right boxes checked when protecting the worksheet
ScreenShot108.png
 

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
1,295
Office Version
  1. 2013
Platform
  1. Windows
All cell areas containing data that must be able to be changed must be released. Select these cell ranges, choose Format Cell, Protection tab, uncheck Locked.
ScreenShot109.png
 

Watch MrExcel Video

Forum statistics

Threads
1,118,884
Messages
5,574,829
Members
412,620
Latest member
sharma7s
Top