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

Discus and support Need Excel 2010 Macro to insert image over 31 sheets on same cell. in Microsoft Office and 365 to solve the problem; 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... Discussion in 'Microsoft Office and 365' started by pintree3, Jul 8, 2020.

  1. pintree3 Win User

    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?

    :)
     
    pintree3, Jul 8, 2020
    #1
  2. Rajesh S Win User

    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.


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


    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.
     
    Rajesh S, Jul 8, 2020
    #2
  3. tpriest Win User
    Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

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


    Need Excel 2010 Macro to insert image over 31 sheets on same cell. [​IMG]


    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.
     
    tpriest, Jul 8, 2020
    #3
  4. Try3 Win User

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

    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.

    Need Excel 2010 Macro to insert image over 31 sheets on same cell. [​IMG]



    Denis
     
    Try3, Jul 8, 2020
    #4
Thema:

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

Loading...
  1. Need Excel 2010 Macro to insert image over 31 sheets on same cell. - Similar Threads - Need Excel 2010

  2. Excel 2010

    in Windows 10 Gaming
    Excel 2010: I want to freeze the top 6 rows and columns 1, 2, and 3, I got it to do more than that but I want just the one I have mentioned. It is critical to the project I am working on, if I can't, I will have to think of something else. Is this even possible????...
  3. Excel 2010

    in Windows 10 Software and Apps
    Excel 2010: I want to freeze the top 6 rows and columns 1, 2, and 3, I got it to do more than that but I want just the one I have mentioned. It is critical to the project I am working on, if I can't, I will have to think of something else. Is this even possible????...
  4. Excel 2010

    in Windows 10 BSOD Crashes and Debugging
    Excel 2010: I want to freeze the top 6 rows and columns 1, 2, and 3, I got it to do more than that but I want just the one I have mentioned. It is critical to the project I am working on, if I can't, I will have to think of something else. Is this even possible????...
  5. Excel work sheet

    in Windows 10 Software and Apps
    Excel work sheet: I have recovered lost/deleted excel worksheet from my HDD by 'minitool power data recovery software'. But when open "format or file extension is not valid" msg window comes. how can I recover my worksheet....
  6. Excel work sheet

    in Windows 10 Gaming
    Excel work sheet: I have recovered lost/deleted excel worksheet from my HDD by 'minitool power data recovery software'. But when open "format or file extension is not valid" msg window comes. how can I recover my worksheet....
  7. Printing multiple images on the same sheet. Fault

    in Windows 10 Customization
    Printing multiple images on the same sheet. Fault: One of our users is having an issue where they: Select 2 JPGs Right click and choose print. Click the Option on the right to print 2 up on a sheet. Click print. The problem... is that the images print but have a massive band of white straight through the images....
  8. Help needed with Excel Attendance Sheet

    in Microsoft Office and 365
    Help needed with Excel Attendance Sheet: So I have this attendance sheet, with this formula for the days of the month, based on this CONFIG sheet, but id like to make the MONTH cell a drop down list, that would change the formula in F16 based on the selected month in the list. [img] ALSO And this seems a bit...
  9. Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

    in Microsoft Office and 365
    Excel 2010 Document Inspector reports hidden sheets, not shown in VBA: I have a worksheet with 14 tabs along the bottom. I've had the worksheet for many years - creation date is 16 November 1997 -and it's evolved over time to be more and more useful. Obviously been through many versions of Excel. It has several user functions and VBA procedures....
  10. Office 2010 Excel: two sheets

    in Microsoft Office and 365
    Office 2010 Excel: two sheets: I have Office 2010 and I know there is some trick to do this, but I cannot find it anywhere. I have two monitors and at work I have the same setup. Person who use to work there I heard said it was a hack that they added to my system so I don't know what that is. Here is what...