Hi ,

I need to protect a shared workbook - other users within the office need to
be able to neter data however do not seem to be able to do this withough
reformatting column widths etc (we have some weird and wonderful people here)

I have tried tried what i though would work - tools - Protect Sheet - then
deselecting format cells, format columns, format rows however this also
prevent users from enetering data.

Any help appreciated.

Try unlocking just the cells that are used for data entry:

Select just the cells that you use for data entry.
'Format' menu -- Cells -- Protection, and untick the 'Locked' box.

Now when you protect your sheet you will still be able to select your cells
for input, but the formatting of your sheet should be preserved.

HTH

Neil
www.nwarwick.co.uk


"G" wrote:

Hi ,

I need to protect a shared workbook - other users within the office need to
be able to neter data however do not seem to be able to do this withough
reformatting column widths etc (we have some weird and wonderful people here)

I have tried tried what i though would work - tools - Protect Sheet - then
deselecting format cells, format columns, format rows however this also
prevent users from enetering data.

Any help appreciated.

G,

Did that work and stop the problem you were having with the
formatting?

I am having the same problem.

T


--
tanyhart
------------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148
View this thread: http://www.excelforum.com/showthread...hreadid=366534