Windows 10: 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?

:)

 

Better overview of different sheets in Microsoft Excel

I would like to suggest you a simple method to create Hyperlink of Sheet Name for easy navigation.





How it works:

• Press Ctrl+K to open the Insert Hyperlink dialog box.
  
• Click the Place in This Document button.
  
• Then link to the sheet, select Sheet name from Cell Reference & press OK.
  
• In Type the Cell reference write the Cell address which you want to
  attach with Sheet's Hyperlink.
  

Note,

• Repeat Step 1 to 3 for other Sheets.
  
• Using this method you can create Sheet's Name list in desire order.
  

 

Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

Here's the list of Objects shown in the VB Project.





So I then ran your List Sheets VB and it led me to what appears to be the issue.

Your List Sheets Sub created a new sheet and listed all the sheets, including the new one and the VB Procedures and Functions. That set me wondering.

So, working on a copy of the XLS, I ran Document Inspector (DI), Hidden Worksheets only, and let it delete those hidden worksheets. And, as I'd wondered, my macros and functions didn't work, they weren't there, DI had deleted them.

So what appears to be the case is that for this workbook at least, DI sees the VB Procedures and Functions items shown in the VB Object List as hidden worksheets, and so deletes them.

I've run DI on other macro-enable spreadsheets but they just have Module 1 containing the macros and are not seen by DI as hidden sheets.

All rather interesting.

 

Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

Just a wild shot in the dark ...

Didn't macros get recorded in worksheets before Excel switched to VBA?
- I can't think how far back this was. Possibly Excel 4 in the early 1990s.
- Of course, this would make no sense at all if your workbook had been created since, say, Excel 2007.

If your workbook is older than that I'd suggest
1 Create a new blank one then, with both open at once, use the sheet tab Move or copy ... to copy each sheet to the new blank workbook.
2 In the VBEditor of the new workbook, create two new modules [Functions, Procedures] and then just copy the code text across from one to the other.
3 In the VBEditor window of the old one, in the Microsoft Excel objects list select each sheet in turn {including ThisWorkbook} then right-click and select View code. If there is anything in any of them, copy it to the same place in the new workbook.





Denis