I am trying to add a button to run a macro in Access 2007 to my Quick Access Toolbar (QAT).
In Excel 2007, I have never had an issue. In the Customize Quick Access Toolbar window I can select Macros from Choose Commands From and then all my non-private macros are listed. I can add them to my ribbon.
However, in Access 2007 nothing shows up in this list of Macros. I feel like there is something in the fundamentals of Access and Macros I am missing but not sure what ...
Thanks for your help.
Adding module example saved as TestModule (see screenshots as well). I still feel I am missing something very simple here ... sigh
Option Compare Database Option Explicit Public Sub HelloWorld() MsgBox "Hello world!" End Sub