Protect Formatting

M

manaadiar

Hi.. I have a file in which other people do some updations.. But eac
time someone does something, either they change the setup of the fil
which makes it appear in two pages instead of 1 etc.. How can i allo
other people to access the file but restrict changes to the pag
setup..??

Thanks..

Manaadiar :confused
 
A

Andy B.

Hi

You can try protecting your sheet and using passwords:

For example if you have an area of your spreadsheet which you want t
protect but there are some cells within which you want users to acces
you can do the following:

Example: say area of spreadsheet: A1:E20 and you want a user t
change cell B2

Highlight the area A1:E20 and go to Format/Cells and click o
protection. Put a tick by Locked. This will lock cells A1:E20

Then go to cell B2, go to format cells for this cell only and click o
protection again. Take the tick off locked

Then go to Tools - Protection and select protect sheet. choose
password for this.

You will then have the area A1:E20 protected but users can change cel
B2 if they want

Hope this helps

Andy B.
 
Top