There are lots of builtin tools that could be added to your favorite toolbar.

Before I'd start creating macros, I'd look through tools|Customize|Commands tab.

You'll find both autofilter and showall icons that you can drag to a toolbar.

(and lots more)

modjoe23 wrote:

Thank you guys for your replies. However, my question was how to create
a macro that is universal. Maybe an example would simplify what I'm
trying to accomplish. I would like to have a button, for example Set
Autofilter On that can be run any time i use excel and with any
workbook to set the autofilter to ON. I know how to create the menubars
and all I just don't know how to the macro application specific rather
than workbook or worksheet specific. I hope this is clearer. Thanks

--
modjoe23
------------------------------------------------------------------------
modjoe23's Profile: http://www.excelforum.com/member.php...o&userid=26376
View this thread: http://www.excelforum.com/showthread...hreadid=398344

--

Dave Peterson