Hi Excel Demigods
I have a spreadsheet that has a certain layout (i.e. borders, colours, etc) which I would like to be protected against all users changing. Although they need to be able to update the cells I do not want them altering the layout. One example is that when a user cuts and pastes one cell into another the borders and colours seem to be altered as well as the cells data. How can I prevent this? I am sure it must be possible, however I need to consult the gods.
Cheers
David
I have a spreadsheet that has a certain layout (i.e. borders, colours, etc) which I would like to be protected against all users changing. Although they need to be able to update the cells I do not want them altering the layout. One example is that when a user cuts and pastes one cell into another the borders and colours seem to be altered as well as the cells data. How can I prevent this? I am sure it must be possible, however I need to consult the gods.
Cheers
David