HI
Is it possible to make a png picture with macro assigned visible or invisible base on a single cell?
say "A1", if empty, the picture will not be visible and if A1 <>"", picture become visible ready to be clicked and carry out assigned task.
please note that i am not using active X command button with inserted picture
but png picture with macro assigned. if it's possible, need vba help. thanks.
It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
File attached. Thanks
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter data in A1 and press the RETURN key or if A1 is not empty, delete the contents.
Please Login or Register to view this content.
Mumps1
Thanks for the code. it work.
quick question,
why picture 3? ActiveSheet.Shapes.Range(Array("Picture 3")).Visible = Target <> ""
Thanks.
You are very welcome."Picture 3" is the name of the picture you inserted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks