Excel insert picture either through macro or button

Hello,

I was asked the following question.

Is there a way to create either a hot key or button or macro that can insert a picture logo that is always in the upper left corner that puts in a certain size when a user selects it.
Then to also distribute it out to users.

Thanks in advance

windows 7 64
excel 2007
rha_mtlAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
gowflowConnect With a Mentor Commented:
This is an Example.

Load the file activate macros, press CTRL S you will see the picture in the corner. Press again CTRL S it will disappear.
Sub ShowPicture()
If Image1.Visible Then
    Image1.Visible = False
Else
    Image1.Visible = True
End If
End Sub

Open in new window


Is this what you want ?
gowflow
Picture.xlsm
0
 
gowflowCommented:
what do you mean by upper left corner ? Cell A1 ? and to answer quickly yes.
gowflow
0
 
rha_mtlAuthor Commented:
Yes sorry Cell A1

How do you do this?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rha_mtlAuthor Commented:
Yes. thats what I want

How do I make it available for all users with my picture?
0
 
gowflowCommented:
Did I answer your initial question ?
if yes, rule says you close that question and if need more then ask a new one with link in here so If you need my help I can assist.

gowflow
0
 
gowflowCommented:
Thank you pls post a link in here of the new question and will be glad to assist. Extending to more users is not that obvious !!!
gowflow
0
 
rha_mtlAuthor Commented:
Please see my other post on how to distribute a macro.

Make excel macro available to all users
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.