Stopping movement of shapes excel 2010

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

Hi Calibra,

Right mouse click on the image and select "Size and Properties". On the properties tab select "Don't move or size with cells" and be sure that "Locked" is checked. When you protect your sheet users will not be able to select the picture. Before protecting the sheet, select the range you want users to be able to edit, right mouse click on the selected range, go to Format Cells. On the protection tab deselect "Locked". When your all done you can protect your sheet and only those cells will be able to be edited.

HTH
Steve

Thanks
Only problem is there are macros attached to the shapes.........so they need to be `clicked on` but i want to prevent them being dragged around.

I have a feeling this isn`t going to be possible !!!!

Use an ActiveX Command button and in the properties you can add a picture to it. Then on the click event for the command button call your macro.

HTH
Steve

My first suggestion worked fine for me. Even after protecting and locking the picture, when I clicked on it it still ran my macro.

Steve

Originally Posted by SteveG

Hi Calibra,

Right mouse click on the image and select "Size and Properties". On the properties tab select "Don't move or size with cells" and be sure that "Locked" is checked. When you protect your sheet users will not be able to select the picture. Before protecting the sheet, select the range you want users to be able to edit, right mouse click on the selected range, go to Format Cells. On the protection tab deselect "Locked". When your all done you can protect your sheet and only those cells will be able to be edited.

HTH
Steve

Hi

Thanks
Is this the method you said worked for you ??? because you said "When you protect your sheet users will not be able to select the picture. " Does this mean they can`t click on it also ???

Thanks

Calibra

Yes. You can click on it and it will trigger the macro. When I said select I meant they couldn't move or edit the picture.

Steve

Just tried this

But I can still right click on images and move them

Using `first` method

Thanks

Hi,

I am not having the same issue. I cannot move the pictures at all so maybe you missed a step? Can post a sample of the workbook?

Steve

Hi Steve

The method specified by you to fix the shapes in place does not really work. After opening and closing the workbook a few times the shapes relocate by themselves. The text box got the most visible movement. The arc and other liniar shapes are OK.
Is there a way of "fixing" the location of those text boxes?
If you want I can send you a sample with a drawing so you can see for youself what I mean.

Cheers
Catalin