Question Adding to the Print Preview Ribbon

[George J]

I found that when trying to export reports to excel, that some produced a subscript out of range error. I wrote a macro to do the exporting and this works.

Is there any way of getting my macro code into a button on the print preview ribbon? I want the users to be able to use my code when previewing rather than the default Access button's.

 

[Ari]

Hi

look at question number two of how to call for a macro.

http://www.ribbon01.com/tutoriais/faq.asp


If you do not know to mount custom ribbon, has the option of setting up a shortcut menu. See how in this article:

http://office.microsoft.com/en-us/a...personalizados-usando-macros-HA010282509.aspx

and

http://www.usandoaccess.com.br/tutoriais/tuto60.asp?id=1#inicio

 

[Old Man Devin]

I think what you actually need to do is to just customise the ribbon. The customisation menus have options to add new buttons for macros. I have only done it once before, but I remember I got it working with ease. You could also try adding the button to the Quick Access toolbar above ribbon, that's nice and easy too (just click the little black arrow up there to add new things).