Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert macro code to an addin
I have created a macro which works perfectly for me but now need to send it
to about 100 others across the planet so they can use it. I could just send them the macro worksheet and they have to have that open and run it. However, they also have to run an add-in which when installed just appears under the 'Data' menu and I'd like to be able to convert this macro to an add-in and have that appear under the 'Data' menu too. Can anyone help please? Cheers ArtySin BTW here's the code if it helps: Sub Insert_Headers() Rows("1:1").Select Selection.Insert Shift:=xlDown Range("A1").Select ActiveCell.FormulaR1C1 = "Plan:Test Name" Range("B1").Select ActiveCell.FormulaR1C1 = "Status" Range("C1").Select ActiveCell.FormulaR1C1 = "Execute Date" Range("D1").Select ActiveCell.FormulaR1C1 = "Time" Range("E1").Select ActiveCell.FormulaR1C1 = "Tester" Range("F1").Select Columns("D:D").Select Selection.NumberFormat = "h:mm" Range("A1:E1").Select Selection.Font.Bold = True Range("A1").Select Dim brkt As Range Set brkt = Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row) For Each C In brkt C.Value = Mid(C.Value, InStr(C.Value, "]") + 1) Next Dim quote As Range Set quote = Range("B1:B" & Cells(Rows.Count, "B").End(xlUp).Row) For Each C In quote C.Value = Mid(C.Value, InStr(C.Value, "'") + 1) Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Pls, how to convert an addin xlam file to xls worksheet in | Excel Discussion (Misc queries) | |||
Convert Excel VBA addin to a Protected Format | Excel Programming | |||
Convert Excel VBA addin to a Protected Format | Excel Programming | |||
Connect a COM AddIn from VBA Code | Excel Programming | |||
using code from an addin | Excel Programming |