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.
Dim wb As Workbook
Dim myPath As String
Dim myFile As String
Dim myExtension As String
Dim FldrPicker As...
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...
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...
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...
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?
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...
This code is perfect but I would like it to perform on all sheets, rather than just the active.
'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...