• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 634
  • Last Modified:

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
0
rha_mtl
Asked:
rha_mtl
  • 4
  • 3
1 Solution
 
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
 
gowflowCommented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now