Hide command button behind pic

[ABabeNChrist]

I have a command button that is within a cell that when selected it insert a picture, the problem I have is when picture is in selected cell (same as command button) I can still view the command button from behind. I set the picture to “view from front” and Command button to “view from rear” but it doesn’t solve anything. I also have the command button checked to not print. Any ideas………………..

[Leith Ross]

Hello ABabeNChrist,

Do you want to hide the button, make it invisible, or just keep the button behind the picture?

[ABabeNChrist]

Hello ABabeNChrist,

Do you want to hide the button, make it invisible, or just keep the button behind the picture?

Hi Lieth Ross
I want the command button to be visible to use, but yet not printable, and once picture is selected the command button goes behind picture, and not visible view. I don’t want command button to be removed, just in case wrong selection was made, that way picture could be deleted and then reuse command button once more to make correct selection. Here is the code I use to inset and size picture.
And yes “just keep it behind picture”
And by the way I’m using Excel 2007

Please Login or Register  to view this content.

[Leith Ross]

Hello ABabeNChrist,

Is the picture going into cell "B1"? Is the CommandButton located in cell B1 also?

[ABabeNChrist]

Hi Leith Ross

Is the picture going into cell "B1

Yes

Is the CommandButton located in cell B1

Yes

[ABabeNChrist]

Any suggestion how I may achieve this.....

[Leith Ross]

Hello ABabeNChrist,

Here is the amended version of the macro...

Please Login or Register  to view this content.

[ABabeNChrist]

Hi Leith Ross
i just tried the code and I got an error on this line

.ZOrder = msoBringForward

Compile error
Argument not optional

I am using Excel 2007 if that make any difference

[Leith Ross]

Hello ABabeNChrist,

Sorry about that. Just force of habit to add an equal sign. The line should read...

Please Login or Register  to view this content.

[ABabeNChrist]

OK the picture was inserted in correct cell and the height was correct but the width was too narrow.
I have a JPG that show picture to the left using new code. even when I try to expand the picture it still does not hide command button (picture to the right).
and I also set the .PrintObject = False to True

[Leith Ross]

Hello ABabeNChrist,

Can you post a copy of the workbook so I can review what is happening in the code?

[ABabeNChrist]

I found why picture was so narrow, I am using merged cells. So I added the range of merged cell and picture sized up correctly, everything is great except I still see the button. See attached picture.
Set MyRange = Range("C4:J4")

[Leith Ross]

Hello ABabeNChrist,

I do not know why the button is still on top. The code works fine in Excel 2003. The picture covers the button and I can select the picture, delete it, and the button is there under the picture.I am at a disadvantage because I do not have Excel 2007. There my be a setting that is missing for 2007 that changes the order of the layers (ZOrder). If you post a copy of the workbook it would help confirm or disprove the hypothesis.

[ABabeNChrist]

Hello ABabeNChrist,

I do not know why the button is still on top. The code works fine in Excel 2003. The picture covers the button and I can select the picture, delete it, and the button is there under the picture.I am at a disadvantage because I do not have Excel 2007. There my be a setting that is missing for 2007 that changes the order of the layers (ZOrder). If you post a copy of the workbook it would help confirm or disprove the hypothesis.

Leith Ross
I just find this thread in regards to .ZOrder msoBringForward that is prabably the problem
http://social.msdn.microsoft.com/For...f-b57b01fc228e

[Leith Ross]

Hello ABabeNChrist,

I am going out for awhile. I will pick this up when I return. Thanks for the informative article.