[computerman29642]

I have placed a command button on one of my worksheets. The command button is used to place an image on the worksheet.

I would like to set the command button's property Enabled to false once it has inserted the image on the worksheet. However, I am unable to figure out how to do that through code.

Also, is there a way through code to determine if teh image was inserted?

[Rollin_Again]

Please post your code that places the image on the worksheet.

Can you also tell us if your command button is from the Forms or Controls Toolbox?

Regards,
Rollin

[computerman29642]

Please see the attached file.

[Rollin_Again]

I stepped through your code it is looks like it already disables the button once the image is inserted. Does it not work for you?

Regards,
Rollin

[computerman29642]

Rollin,

I apologize. Yes, it does work for me. I am working on multiple things at once, and I just read where you asked to see the code.

[Zack Barresse]

World domination plans can be overwhelming at times. Multi-tasking is essential.

[computerman29642]

LOL...You're telling me. I am exhausted.

I guess the main question now is what do you think about the code. Is there a better way I could have handle some aspects of the code (or all the code)?

[Zack Barresse]

Yeah, the code looks good. The only thing I'd look at maybe not using us the ActiveSheet, and that's just my severe aversion to it (as you know).

[computerman29642]

Yeah...I do not like using ActiveSheet either (after you have critic my codes before).

Did you get the code I sent to you through e-mail? That is actually the most current version of the code

[computerman29642]

Please see the updated Excel Workbook.

This is how the current code looks.

[Zack Barresse]

I did get it via email. Saw this post and figured I'd post here. Trying to read VBA on my handheld is a bit precarious, it was the first time I'd done it. I got some funny looks while trying to scroll through it, I guess I looked intense. LOL!

But the code looks good. It's simple, elegant, does what you want, references are explicit, and it's backwards/forwards compatible. I think you have a winner.

[computerman29642]

Thanks Zack.