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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top