PDA

View Full Version : Solved: Disable right click on images



khalid79m
01-12-2010, 10:56 AM
I have imported some fancy icons which I am using as buttons to run macros.

I have disabled the right click function, but it still allows you to select the images(icons).

Can I disable it so that the righ click will not select the images.

khalid79m
01-12-2010, 03:59 PM
can anyone help I have tried application.commandbars(cell).enabled = false, this only disables right click on cells not images

GTO
01-12-2010, 07:48 PM
Hi there,

I might be misunderstanding, or just plain wrong, but I believe you'd have to protect the sheet to prevent objects from being selected.

Mark

khalid79m
01-13-2010, 03:25 PM
thanks gto, the sheets are protected already... you can select the images but you cant move them as they are locked.

strange in excel 2007 what it works you cant right click on the image if it is in a protected sheet.. so why is it differen in 2003

khalid79m
01-13-2010, 03:30 PM
i figured it out , on 2003 you need to deselect the objects when protecting the sheet. thanks GTO