I have a macro that opens a comment box for appending. The problem is that
it only works when executed via the Tools, Macro, etc. sequence. If a hotkey
is assigned and used to execute, the macro only adds a blank comment if no
comment existed - but even this isn't open when the macro terminates. I am
using SendKeys "%ie%" to open the comment (and leave it open). Any ideas why
this won't work with a hot key (but does via the toolbar sequence) or
suggestions for another way to accomplish this same thing?

I don't know the technical reasons why it doesn't work--I'd guess Sendkeys
fights with your shortcut key.

But maybe you could add a button to the sheet that's assigned that macro.

Or maybe you could add a button to a toolbar that runs that macro.

Tools|customize|customize tab|macros category
drag the custom button to your favorite toolbar.
Assign your macro to that button.

If you close your workbook, excel will open the workbook with that macro when
you click that icon.

But if you share this workbook (or even rename the workbook), it can become a
maintenance nightmare.

You could build a toolbar on the fly when your workbook opens and delete that
workbook when you close your workbook.

Here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

roadkill wrote:

I have a macro that opens a comment box for appending. The problem is that
it only works when executed via the Tools, Macro, etc. sequence. If a hotkey
is assigned and used to execute, the macro only adds a blank comment if no
comment existed - but even this isn't open when the macro terminates. I am
using SendKeys "%ie%" to open the comment (and leave it open). Any ideas why
this won't work with a hot key (but does via the toolbar sequence) or
suggestions for another way to accomplish this same thing?

--

Dave Peterson