all sheets

  1. V

    What and where put code to run macro in all sheets (in opened workbook)

    My problem is, where and what to put inside my macro to run macro in all sheets in currently opened workbook. I tried several things but without success. Sub LoopAllExcelFilesInFolder() Dim wb As Workbook Dim myPath As String Dim myFile As String Dim myExtension As String Dim FldrPicker As...
  2. H

    Macro to add buttons to every sheet except first sheet

    I have an excel file where the first sheet is an index of all the sheets in the workbook. I need a macro that adds three buttons to every sheet except for the first sheet (the index) I will need to run this macro again and again as new sheets are added. Rather than searching for the new sheets...
  3. S

    Repeat action to all sheets in workbook

    Hi guys, Can someone help me how I want to make this codes more shorter? which is I can apply this code in all sheets in open workbook? For workbook that have only 29 sheets is still ok for me, but after this I will have 63 sheets every workbook. I had found this code, but it's not work for me...
  4. S

    Quick Question about applying macro to multiple sheets

    Is there a way to run the codes below on every sheet in my workbook? I have 50+ sheets (tab1, tab2, tab3... tab50...) I musto to change column B and X to upper case and after do action find and replace. I using 2 macros, 1st is for change case to upper case, 2nd for find EXAMPLE 1 and replace...
  5. E

    VBA: Email individual Sheets to email value in cell

    I want to email each sheet in my workbook (30 sheets) to the email address in cell A1. The email address is different on each sheet. What I have below works for the active sheet but isn't attaching it. Can anyone help?
  6. T

    macro truncating cell on all worksheet.

    hi, i wanted to write a macro that would truncate the cell B1 to 10 character from the right. Then rename the sheet with the right bit of the cell. And finally delete both cells. And repeat this process with all sheet in the workbook (they all contain a section number and section description in...
  7. A

    Hide/Unhide control all sheets.

    This code is perfect but I would like it to perform on all sheets, rather than just the active. Sub Shapes2() 'Loop through the Shapes collection and use the Type number of the control Dim myshape As Shape For Each myshape In ActiveSheet.Shapes ' ActiveX control (control...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top