Hi All,

Having a bit of trouble.

I want to be able to lock the size and colour etc of a shape in excel while still being able to select it and move it around the sheet.

To give it a bit of context, I have a virtual white board so to speak in excel and use the shapes as magnets to be placed on the "white board".

The problem is that I don't want the people that use this spread sheet to be able to change the size, colour or the text contents or the shape but still be able to move it.

Any help or any ideas on an alternative would be greatly appreciated.