Hi
I have previously had some experience of visual basic, but with office 2003.

I have now begun a project to write a recipe book with excel 2010. I have a `menu` page which links to various tabs ( sheets) via VBA, which hold the recipe information. These`sheets` have various shapes which have a Macro attached to navigate back to the menu page.

I want to lock these shapes from moving or being dragged / accidentally deleted, but still allowing text to be entered / modified in the cells.

I would have thought this to be easy, but can`t find a way of doing it.

Any help would be appreciated

Thanks

Calibra