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

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!

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