Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-01-2016, 03:50 AM
macropod's Avatar
macropod macropod is offline Insert picture placeholder in spreadsheet Windows 7 64bit Insert picture placeholder in spreadsheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you insert an Active-X image control and position/size it where you want the picture to go, you could use a macro like:
Code:
Private Sub Image1_Click()
With Application.Dialogs(xlDialogInsertPicture)
  If .Show = True Then
    With Selection.ShapeRange
      .Width = Image1.Width
      .Height = Image1.Height
      .Top = Image1.Top
      .Left = Image1.Left
    End With
  End If
End With
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert picture placeholder in spreadsheet slidemaster view, insert placeholder greyed out banjodaddy PowerPoint 1 01-14-2016 03:28 PM
Insert picture placeholder in spreadsheet "Insert Picture\Link to File..." embeds picture sinz54 Drawing and Graphics 1 09-29-2013 06:31 PM
Insert picture placeholder in spreadsheet SlideMaster: Date Placeholder, Footer Placeholder, Slide Number Placeholder? tinfanide PowerPoint 1 04-05-2013 10:37 AM
Insert picture placeholder in spreadsheet Picture Placeholder problem lerningdaily PowerPoint 2 03-04-2013 02:09 AM
Insert picture placeholder in spreadsheet Picture "Placeholder" in Word 2003 legodan Drawing and Graphics 1 10-31-2011 02:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft