Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108574

Re: Insert from paint and resize

Show all headers | View raw

Hi Steve,

Am Thu, 25 Feb 2016 08:35:53 -0800 (PST) schrieb Steven@pctamers.eu:

> thanks for this fast response. The Paint object doesn't seem to be picking up the SigPic name . . . once it's inserted, if I select it, it's named "Object1" (and of course the number increments for each new Paint object I insert). 
> 
> Perhaps the line of code that inserts the Paint object needs modifying, but I can't see where or how, it looks pretty good to me !!??

the OP should save a signature and insert it from this path. So he save
signing for each workbook.

Save a signature, modify the path in the code and test it:

Dim SigPic As Picture

Set SigPic = ActiveSheet.Pictures.Insert("C:\Users\claus\OneDrive\Bilder\Screenshots\Signature.jpg")

With Range("B39")
    SigPic.Top = .Top
    SigPic.Height = .Height
    SigPic.Left = .Left
    SigPic.Width = .Width
End With


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Insert from paint and resize Steven@pctamers.eu - 2016-02-25 04:38 -0800
  Re: Insert from paint and resize Claus Busch <claus_busch@t-online.de> - 2016-02-25 14:22 +0100
    Re: Insert from paint and resize Steven@pctamers.eu - 2016-02-25 08:35 -0800
      Re: Insert from paint and resize Claus Busch <claus_busch@t-online.de> - 2016-02-25 18:09 +0100
        Re: Insert from paint and resize Steven@pctamers.eu - 2016-02-25 09:22 -0800
          Re: Insert from paint and resize Claus Busch <claus_busch@t-online.de> - 2016-02-25 18:34 +0100
            Re: Insert from paint and resize Steven@pctamers.eu - 2016-02-25 10:25 -0800
              Re: Insert from paint and resize Claus Busch <claus_busch@t-online.de> - 2016-02-25 19:53 +0100
                Re: Insert from paint and resize Steven@pctamers.eu - 2016-02-26 06:44 -0800
  Re: Insert from paint and resize Steven@pctamers.eu - 2016-02-25 11:13 -0800

csiph-web