Need Excel 2010 Macro to insert image over 31 sheets on same cell.


  1. Posts : 88
    Windows 10 Pro
       #1

    Need Excel 2010 Macro to insert image over 31 sheets on same cell.


    I have 15 spread sheets. Each one with a front page (sheet = the tabs at the bottom). Tab 2 to tab 32 on the same cell (46 F) I need to insert an image (My digital signature).
    This means 15 X 31 whereby I have to insert this. I was thinking that perhaps there is a way of doing a macro or something similar, whereby I do it once and then automatically my signature gets inserted on the other 30 sheets. Can anyone guide me how to do so please?
      My Computer


  2. Posts : 16,145
    Win 10 Pro 64-bit v1909 - Build 18363 Custom ISO Install
       #2

    Hello @pintree3,

    pintree3 said:
    I have 15 spread sheets. Each one with a front page (sheet = the tabs at the bottom). Tab 2 to tab 32 on the same cell (46 F) I need to insert an image (My digital signature).
    This means 15 X 31 whereby I have to insert this. I was thinking that perhaps there is a way of doing a macro or something similar, whereby I do it once and then automatically my signature gets inserted on the other 30 sheets. Can anyone guide me how to do so please?
    Do you mean something like this? . . .

    TRY THIS ON A TEST FILE FIRST!
    Change the file location and cell reference accordingly.


    Code:
    Option Explicit
    
    Sub Inset_My_Digital_Signature()
      Dim strPath As String
      Dim shtSheet As Worksheet
      Application.ScreenUpdating = False
      strPath = "C:\My_Digital_Signature_Folder\My_Digital_Signature.bmp"
      For Each shtSheet In Worksheets
        shtSheet.Activate
        Range("A1").Select
        ActiveSheet.Pictures.Insert (strPath)
      Next shtSheet
      Set shtSheet = Nothing
      Application.ScreenUpdating = True
    End Sub
    I hope this helps!
      My Computer


  3. Posts : 88
    Windows 10 Pro
    Thread Starter
       #3

    Thanks Paul Black I really appreciate your help. I apologize for taking longer than usual to reply and equally apologize for forgetting to mention I am totally "Excel-illiterate".
    In other words there is no way of me finding out if what you wrote works or not because I do not know the steps needed before and after your script. I can easily cut and paste what you wrote somewhere (making the appropriate changes) but where do I go to create such a thing? What tab and button within Excel do I need to go to to create it. And once done then what? Does it save itself automatically? And now do I run it? As said totally illiterate.
      My Computer


  4. Posts : 16,145
    Win 10 Pro 64-bit v1909 - Build 18363 Custom ISO Install
       #4

    Hello @pintree3, did you ever manage to sort this out?
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 10:05.
Find Us




Windows 10 Forums