Addin macro
On May 31, 8:44 am, Canlink wrote:
On May 30, 8:44 pm, RS wrote:
I’ve got a macro in an addin that’s installed in excel 2003 and I want to
assign a button to that sub. When I try to assign it to a button I can not
see it in the macro selection box. I have it as a public sub as follows:
Public Sub MergeFormatCells()
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlTop
.WrapText = True
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = True
End With
End Sub
I’m trying to assign this to the excel toolbar button for all workbook and
not just assign it to one workbook.
Hi R.
Check the General - Declararations of the Module containing the
macro. Macros are hidden but usable by typing the name into the run
box if you see "Option Private Module". You can delete these words and then see the macro if you wish.
Regards
Geoff
|