Software

Ask something
Discussion Locked

Cell format protection in Excel 97

0 helpful
7 replies

by shanna

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi everyone,

Does anyone know of a way to protect a spreadsheet so that our users cannot change the formatting of the cells in any way... without getting into needing to enter a password to modify the document? Our users keep resizing the heightsand widths and it's getting quite frustrating.

Any help would be much appreciated.

7 replies

by dklippert

Select the cells that you want to allow changes. Go to Format>Cells and choose the Protection tab.
Remove the "Locked" check mark.
Now go to Tools>Protection. Choose Protect Worksheet and give it a password.
Users will be able to make entries in the UN-locked cells, but they won't be able to change the Worksheet.

by r. a. caluste

record a macro. resize your cells into proper width and height. save the macro. run the macro everytime they open or close the document.

hope this helps.

by aisling

If your users use the mouse and the column and row headers to resize, then try using the Tools - Options menu. On the View tab, untick the "Row & Column Headers" box. Now your spreadsheet will not show the A, B, C etc or the 1, 2, 3 etc for row and column headings and editing these now requires the use of the format menu instead of the mouse.

This discussion is closed to new replies.