I see that with "Application.MacroOptions", I can set the description
and shortcutkey for a macro, but how do i retrieve the macro description?

This Addin may be of use to you ?
It will list your Macro shortcut keys, Macro Name and Discription.

http://www.xcelfiles.com/GetShortCutKeys.html