Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
Macro problem | New Users to Excel | |||
Circular Problem needs Macro | Excel Discussion (Misc queries) | |||
Problem executing a macro from different workbook where it is | Excel Discussion (Misc queries) | |||
Where to stick macro to change default comment font? | Excel Discussion (Misc queries) |