access vba - adding macro shortcut to ribbon

Hello all,
I've been working with Excel VBA extensively for a couple years now and starting to migrate all of our data to Access and have been learning that environment. My first question is a silly one. I just created a simple routine within a module to close all objects. I'm trying to create a quick key in the ribbon like you can do in Excel, but in the Options, the sub doesn't show up under the Macro dropdown. I'm not sure why, because the sub works when run from the VBA window. I've closed and reopened the db, but I'm obviously missing something here and any help would be appreciated. The code:

Please Login or Register  to view this content.

Hi there,

I just created a simple routine within a module to close all objects

As far as I am aware, only routines which are defined in the "Macros" tab can be assigned to buttons in the Ribbon.


Hope this helps.

Regards,

Greg M

Thanks, Greg. I'll look into that.