Windows XP, Excel 2007.
I am creating some macros that need to be used across many workbooks. Over time, there may need to be changes so I wanted to put them in an add-in so they could be updated once rather than having to remove and copy back in the updated modules.
The add-in is created and in the VBE I can run the macro and it works. However I do not see it when I open the 'run macros' prompt, nor can I add it by right-clicking on a button because it is not listed when I choose 'assign macro.'
These macros need to be triggered by buttons. I have a workaround, which is to create a small sub for every single button that links to the add-in:
Sub Button2_Click()
Application.Run "UpdateRight"
End Sub
But I really don't like this because it will be time-consuming to do this for each button and not easy to edit on the fly for a particular button.
What do I need to do to have these macros show up along with my other macros (ones saved in the workbook or those from my personal workbook)?
I am creating some macros that need to be used across many workbooks. Over time, there may need to be changes so I wanted to put them in an add-in so they could be updated once rather than having to remove and copy back in the updated modules.
The add-in is created and in the VBE I can run the macro and it works. However I do not see it when I open the 'run macros' prompt, nor can I add it by right-clicking on a button because it is not listed when I choose 'assign macro.'
These macros need to be triggered by buttons. I have a workaround, which is to create a small sub for every single button that links to the add-in:
Sub Button2_Click()
Application.Run "UpdateRight"
End Sub
But I really don't like this because it will be time-consuming to do this for each button and not easy to edit on the fly for a particular button.
What do I need to do to have these macros show up along with my other macros (ones saved in the workbook or those from my personal workbook)?
